search cancel

Verify which SQL Server a Notification Server is pointing to

book

Article ID: 175893

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

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

Environment

IT Mangement Suite (ITMS) 8.1 and 8.5

Resolution

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.

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

 

Attachments