Database collation error while accessing NS console.

Article Id: 158771

Status: Published

Updated On: 19-02-2015 14:25

Legacy Id: TECH213334

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.