ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Database collation error while accessing NS console.
Article ID: 158771
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
Feedback
Yes
No
Powered by
