The connection string is built from values stored in the coresettings.config file which you will find under C:\ProgramData\Symantec\SMP\Settings.
There are five values stored for the db connection in this file:
- DbServer
- DbCatalog
- DbUser
- DbPassword
- UseApplicationIdentity
The DbPassword value is encrypted.
To change the database used by the SMP you can follow HighTower's instructions and go to Settings > Notification Server > Database Settings in the console.
If you do not have access to the console, you can change the settings on the server using the aexconfig.exe command line tool. This tool is in the C:\Program Files\Altiris\Notification Server\bin folder.
The syntax is
aexconfig dbserver:<server name> dbname:<database name> dbusername:<db user n
ame> dbpassword:<db user password> dbtimeout:<db timeout>
Examples
To connect to the Symantec_CMDB database on a server called ATRSNS1, with the user "pippo" and password "password1"
aexconfig /db dbserver:ATRSNS1 dbname:Symantec_CMDB dbusername:pippo dbpassword:password1 dbtimeout:600
To connect to the Symantec_CMDB database on a server called ATRSNS2 using Integrated Security:
aexconfig /db dbserver:ATRSNS2 dbname:Symantec_CMDB dbusername: dbpassword: dbtimeout:600