Database collation error while accessing NS console.

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

Database collation error while accessing NS console.

Symantec CMDB database collation was different from the collation of the Master Database.

Resolution

 

Follow the below steps:

 

1. Stop Altiris services on the SMP Server.

2. Backup the database Symantec_CMDB then detach on the SQL server.

3. Uninstall the SQL Server

4. Reinstall the SQL Server then rebuild the system database

    Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=<instance name> /SQLSYSADMINACCOUNTS=<app id> /SAPWD=<sa password> /SQLCOLLATION=Latin1_General_CI_AI

5. Attach the Symantec_CMDB database on the SQL server.

6. Reconfigure the SMP using the below command:

AeXConfig.exe /svcid user:GDC\user.001 password:****** /db dbserver:MSSQLSERVER1\ALTIRIS dbname:Symantec_CMDB dbusername:sa dbpassword:xxxxx dbtimeout:9004.