Onebeat compatibility with SQL Server

This article includes the following parts: 

1. Overview

2. SQL Server Express

2.1 Limitations

2.2 Special Settings

3. How to identify the SQL Server Version & Edition

Overview

Onebeat is compatible with the following SQL Server Versions:

* From Version 8: SQL Server 2016 Standard / Enterprise

* From Version 7: SQL Server 2012 Standard / Enterprise 

* SQL Server 2008 R2 Standard / Enterprise

* SQL Server 2008 Standard / Enterprise

In addition, Onebeat is compatible with the Express edition for the above SQL Server Versions. 

SQL Server Express

SQL Server Express is a free edition of SQL Server, and it’s used as the internal database for third-party products.

However, it also has several limitations.

SQL Server Express edition limitations:

• Database size limitation: the maximum relational database size is 10GB

• Memory limitation: the maximum memory for the database engine is limited to 1GB

For the full limitations list which is detailed in the Microsoft website go to the following link:

• SQL Server 2008 R2 Express

• SQL Server 2012 Express 

Special Settings

SSA Configurations for SQL Express

While using SQL Express there is no option to use 'Localhost' as Server name in the SSA.

Therefore there is a need to use the SQL Server and Instance name.

The instructions:

1. Open the SSA > Connection > in the 'Server Name' enter the SQL server name (as it shows in the SQL Server Management) > press 'Add' > choose it in the Servers List > and press the 'Save Server Configuration'

2. Restart Onebeat Server

How to Identify the SQL Server Version & Edition?

Applicable on all versions of SQL Server:

Run the following command in Management Studio:

SELECT @@VERSION