How To: Check your SQL Server version and database compatibility level

Background

The Adaptiva OneSite Server must run on SQL Server 2017 (14.0.1000) or higher, with a compatibility level of 140 or higher for the adaptiva database. If you are upgrading from 9.1.xxx to 9.2.967.23 or later, you may need to upgrade the SQL Server that is hosting the adaptiva database.

You can use the following queries to determine your SQL Server version and the compatibility level of the adaptiva database.

Solution

In SQL Management Studio, execute the following query:

-- Check SQL Version
SELECT serverproperty('ProductVersion') as [ProductVersion]

-- Check Database Compatibility level
SELECT name, compatibility_level
FROM   sys.databases
WHERE  name = 'adaptiva'

This query assumes that the adaptiva database exists and that the name was not changed from the default. If the results returned show the SQL Server version is less than 14.0.1000 (SQL Server 2017) or the database compatibility level is less than 140, do not install or upgrade the Adaptiva OneSite Server.

Support

If you have any questions, please contact support via the Adaptiva Support Portal or email ticket@adaptiva.com.