Verify which SQL Server a Notification Server is pointing to

Products

• IT Management Suite

Issue/Introduction

You want to know which SQL Server your Notification Server is pointing to.

Environment

IT Management Suite (ITMS) 8.x

Resolution

In this example, the name of the SQL Server is "SQLServerName".

There are four places to look on the Notification Server to verify the location of the CMDB.

1. Database Settings on the Notification Server

Check on the SMP Console under:

Settings>All Settings>Notification Server>Database Settings

 

2. 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).

3. 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.

4. 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 settings.

1. The setting to check is <customSetting key="DbServer" type="local" value="<SQLServerName>" />
2. 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: