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.