Upgrade to 7.6 SMP Fails with Failed to Configure Database Settings Error

Products

• IT Management Suite

Issue/Introduction

The upgrade from 7.5 to 7.6 proceeds to step 5 (configuring the database) in Symantec Installation Manager (SIM) and then fails.

A critical error occurred:

System.Web.Services.Protocols.SoapException: Failed to configure database settings. --->

Altiris.NS.Exceptions.AeXException: Failed to configure database settings. ---> Altiris.NS.Exceptions.AeXException: SQL compatibility mode is too low for [Symantec_CMDB]: SQL Server 2005, (required: SQL Server 2008)

...

 

Critical Error Occurred during configuring database - "system.web.services.protocols.soapexception: Failed to configure database settings"

 

ConfigureNS - task_Completed(): Configuration Task Configuring database... Failed: System.Web.Services.Protocols.SoapException: Failed to configure database settings. ---> Altiris.NS.Exceptions.AeXException: Failed to configure database settings. ---> Altiris.NS.Exceptions.AeXException: SQL compatibility mode is too low for [Symantec_CMDB]: SQL Server 2005, (required: SQL Server 2008)

...

Cause

The Symantec_CMDB database is set to an outdated compatibility mode that is not supported by 7.6.

Resolution

Open SQL Server Management Studio on the SQL Server. Find the Symantec_CMDB (Might be named differently) database. Right-click on the database on select Properties. In the Database Properties window that opens go to Options and find the Compatibility level field. Set the compatibility mode to SQL Server 2008 (100).

On the NS return to the Installed Products page in SIM. Symantec Management Platform 7.6 should show as partially installed and present a Reconfigure button. Click the Reconfigure button and wait for Management Platform 7.6 to be reconfigured. Once the reconfiguration is complete, repeat the same process for each of the solutions to reconfigure them.