3.6 Modifying Aegis Repository Configuration

During installation, you specify the SQL Server computer that hosts the Aegis and Resource Management databases and the authentication method the providers use to communicate with them. After installation is complete, if you move the database to another host or modify the logon credentials, the providers cannot communicate with the databases. You must manually update the host information or logon credentials in the Aegis Adapter Configuration Utility.

To update the location or logon credentials for a database:

  1. Log on to the Aegis Server computer with an Administrator account.

  2. Stop the following services:

    • NetIQ Aegis Activity Broker

    • NetIQ Aegis Correlation Engine

    • NetIQ Aegis Engine

    • NetIQ Aegis Namespace Provider

  3. If the Aegis Server and Web Server are on the same computer in your environment, stop the NetIQ Aegis Business Services service.

  4. If you are moving a database to another server computer, complete the following steps:

    1. Log on to the Database Server computer with an Administrator account.

    2. Stop the database you want to move.

    3. Perform a full backup of the database.

    4. Log on to the new server computer with an Administrator account.

    5. Restore the backup on the new server computer.

  5. To install the SQL Server Agent jobs on the new Database Server computer, perform the following steps:

    1. On the Aegis Server computer, open a command prompt for each of the following locations:

      • C:\Program Files\NetIQ\Aegis\DB\PGE

      • C:\Program Files\NetIQ\Aegis\DB\RPT

      • C:\Program Files\NetIQ\Aegis\iqrmdb\IQRM

    2. For each location, type the following command:

      sqlcmd -b -S Server -U " SqlUser " -P " SqlPwd " -i InstallJobs.sql

      Where:

      • Server is the name of the new Database Server computer, including the instance, such as HOUAE001\Instance1.

      • SqlUser andSqlPwd are the user name and password for SQL authentication. If you use Windows authentication, do not include these options in the command.

  6. On the Aegis Server computer, in the NetIQ program group, click Aegis > NetIQ Aegis Adapter Configuration Utility.

  7. In the left pane, expand Aegis Repositories, and then click the database you want to update.

  8. In the view pane, provide the new server location or logon credentials, and then click Test Database Connection.

  9. If the test connection is successful, click Exit.

  10. Restart the following services:

    • NetIQ Aegis Activity Broker

    • NetIQ Aegis Correlation Engine

    • NetIQ Aegis Engine

    • NetIQ Aegis Namespace Provider

  11. If the Aegis Server and Web Server are on the same computer in your environment, restart the NetIQ Aegis Business Services service.

  12. If you moved a database to another server computer, make a backup copy of the old database before you delete it.