Establishing the Database Connection

You must establish a connection between the Alarm DB Logger and the alarm database.

The Alarm DB Logger works with SQL Server and Windows authentication. The SQL Server installation must be set to mixed mode.

To configure the database connection

1. Open the Alarm DB Logger Manager. Do the following:

   1. In the Tools view, expand Applications.

   2. Double-click Alarm DB Logger Manager.

2. Click Settings. The Alarm DB Logger Manager - Configuration wizard appears.

   

3. Configure the database connection. Do the following:

   1. In the Authentication list, select the authentication method: SQL Server Authentication or Windows Authentication (default).

      Note: Windows authentication can provide better application security than SQL Authentication. If you switch from Windows Authentication to SQL Authentication, a pop up dialog will appear recommending that you use Windows Authentication for this reason. If you choose to ignore this warning and proceed with SQL Authentication, click OK. A similar message will be logged in the SMC Log Viewer.

   2. In the Server Name box, enter the node name of the computer where the alarm database is installed.

   3. In the Database box, type the name of the InTouch alarm database.

   4. In User Name box, type the user account name created for the alarm database.

   5. In the Password box, type the password associated with the alarm database user account.

   Note: The Windows Authentication method uses the credentials of the user currently logged in, and disables the user name and password fields.

4. In the Logging Mode area, configure how records are stored. Do either of the following:

   1. Click Detailed to store a separate record for each alarm condition (in alarm, acknowledged, and returned to normal).

   2. Click Consolidated to store all states of an alarm (in alarm, acknowledged, and returned to normal) in a single record with time stamps for each transition.

5. Click Create to create the database, if required.

6. Click Test Connection to verify connectivity to the alarm database. A message indicates a successful connection to the database.

7. Click Next to configure which alarms to log. See Configuring Which Alarms to Log for detailed instructions.