You want to know which SQL Server your Notification Server is pointing to.
IT Mangement Suite (ITMS) 8.1 and 8.5
In this example, the name of the SQL Server is "SQL-W2K8-01".
There are four places to look on the Notification Server to verify the location of the CMDB.
Symantec Installation Manager on the Notification Server
First, run the Symantec Installation Manager (SIM) on the Notification Server and click on "Configure Settings" and then double-click on "Configure Database Settings". You will see the following screen. The SQL Server name is found in the drop-down called "SQL Server name" (Red Arrow below).
Windows Registry on the Notification Server
Next, there are two Windows Registry keys to check.
HKEY_LOCAL_MACHINE\SOFTWARE\Altiris\AIM\Configuration\NsConfiguration and look at SqlServerName to verify the SQL Server name.
HKEY_LOCAL_MACHINE\SOFTWARE\Altiris\eXpress\Notification Server and look at DBDsn to verify the SQL Server name.
CoreSettings.config or NSConfigurator on the Notification Server
Finally, you will check the CoreSettings.config found at: C:\ProgramData\Symantec\SMP\Settings\CoreSettings.config.
Make a copy of the CoreSettings.config and place it in a directory so you can open it with Notepad or Notepad++ and check the setting.
The setting to check is <customSetting key="DbServer" type="local" value="SQL-W2K8-01" />
To edit the CoreSettings.config, use NSConfigurator.exe, found at C:\Program Files\Altiris\Notification Server\Bin\Tools
You can also use NSConfigurator (C:\Program Files\Altiris\Notification Server\Bin\Tools\NSConfigurator.exe) to view the setting.
You will find the setting here:
Subscribing will provide email updates when this Article is updated. Login is required.