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.