While upgrading / migrating to a new version, an error appears that Microsoft SQL server 2008 or lower compatibility level is configured for current database

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

While upgrading from 8.0 HF6 to 8.5 version an error is popped that Microsoft SQL server 2008 or lower compatibility level is configured for the current database. Microsoft SQL Server 2008 compatibility level is not supported from SMP 8.5 onwards.

Environment

IT Management Suite versions 8.x

Cause

A lower compatibility level is configured for the current database. Microsoft SQL Server 2008 compatibility level is not supported from SMP 8.5 onwards.

We have the following statement in upgrade documentation.

 

Resolution

To proceed with the upgrade, we need to configure the existing database with SQL 2012/2014 compatibility level. This change needs to be performed on the SQL Server Management Studio.

1. Log in to SQL Server Management Studio.

2. Run below select query against Altiris Database and you can find your existing database compatibility level:

***********
USE Symantec_CMDB;  
GO  
SELECT compatibility_level  
FROM sys.databases WHERE name = 'Symantec_CMDB';  
GO  
***********

Note: You need to enter the database name of your existing Altiris database.

3. Change the compatibility level in your environment to the Default Compatibility Level Designation for 2012/2014 i.e 110/120 to proceed further with the upgrade of ITMS.

4. The same can be done in the following ways:

* Right-click on Symantec_CMDB database and click on Properties.

* Under Database Properties go to Options.

* You can now find the existing database Compatibility level on this page.

* Change the compatibility level to 2012/2014 and proceed with the upgrade.



OR

You can run the below query:

*************
ALTER DATABASE Symantec_CMDB
SET COMPATIBILITY_LEVEL = 110
*************
Note: You need to enter the database name of your existing Altiris database.


5. Now run the select query from step-2 and verify if the compatibility level is modified. Once verified the upgrade should proceed without this error.

Please take a complete database backup before performing the above steps.

Additional Information

211591 "Patch Management Solution is failing to upgrade: 'TRY_CONVERT' is not a recognized built-in function name."