Using Notification Manager › Optional Configuration Tasks › How You Create Or Update a Notification Manager Database on a Non-CA Automation Point Server

How You Create Or Update a Notification Manager Database on a Non-CA Automation Point Server

A Notification Manager database can reside on a server where CA Automation Point is not installed. This lets you centralize your databases and minimizes the number of Microsoft SQL Server licenses your site requires. CA Automation Point can remotely connect to a Notification Manager database created on another system.

You must install a supported version of Microsoft SQL Server on any server machine where the Notification Manager database is to reside.

Note: For supported releases of Microsoft SQL Server, see the chapter "System Information" in the CA Automation Point Release Notes.

After you install (or upgrade) a CA Automation Point server on one machine, you need to install (or upgrade) a remote database.

To install a remote database

1. On the remote server, login as a user who has the SQL privilege to update SQL databases using Windows authentication. Make sure that the SQL command-line utility osql.exe is on that user's PATH.
2. Start the CA Automation Point installation program from the CA Automation Point DVD.
3. Select Setup Remote NM database.
4. Enter the appropriate values into the fields on the dialog.
5. Click Setup to create or update the NM database schema on the local system.
6. Return to your CA Automation Point server, and navigate to Configuration Manager, Expert Interface, Notification Services, Notification Manager, NM Setup.
7. Establish a connection from CA Automation Point to the remote NM database. This populates the database with initial values. If you already established access to a remote database in your previous CA Automation Point release, disable access, click OK, and then re-enable access. This confirms that CA Automation Point can establish a connection and properly recognize the recently updated remote database.