ELMA and MSSQL SERVER compatibility

If you use MSSQL Server 2014 or higher, you need to set the compatibility level of all ELMA databases to MSSQL Server 2012 (or MSSQL Server 2008).

In this article, we will show you how to do that when you create a new database:

  1. Open the database creation wizard:

     2. Go to Options page and set the Compatibility level to SQL Server 2008 (100):

You can also change the compatibility level of existing databases. Please see this article to learn how to do that.