How do I create a new database or change the database being used by Symantec Management Platform?

book

Article ID: 181843

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question

How can I create a new database, or change the database that is being used by an SMP 7.0, 7.1, or 7.5 installation?

Answer
NSSetup is no longer supported in SMP / Notification Server 7.
 

There are two supported methods to alter database settings.

  1. Within the console: If you are able to access the Symantec Management Console, go to Settings - Notification Server Settings - Database Settings. Use the options on this page to create a new database or to change the database currently being used by Notification Server.
  2. Using AeXConfig.exe: When you don't have access to the SMC, Run AeXConfig.exe /db from a command prompt. It is found in the directory \Program Files\Altiris\Notification Server\bin.  Syntax examples are shown below:

    1. To connect to the SQL Server using Windows Integrated Security, under the account credentials of the current cmd.exe process:

      AeXConfig.exe /db dbserver:<SQLServerName> dbname:<DBName> dbusername: dbpassword: dbtimeout:<DBTimeout>
       
    2. To connect to the SQL Server using a SQL Login:

      AeXConfig.exe /db dbserver:<SQLServerName> dbname:<DBName> dbusername:<SQLLoginName> dbpassword:<SQLLoginPassword> dbtimeout:<DBTimeout>

 

NOTE: You must use all of the parameters for the command to work, but for Integrated Security to work using the account credentials of the currently executing cmd.exe process, do not put the user name or password after the dbusername: and dbpassword: parameters.