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.
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).
Next, there are two Windows Registry keys to check.
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.
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: