Database collation error while accessing NS console.

book

Article ID: 158771

calendar_today

Updated On:

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.

Attachments