Establish 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.

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. Select Settings. The Alarm DB Logger Manager - Configuration wizard appears.

   

3. In the SQL Server/MSDE section, 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 dialog will appear recommending that you use Windows Authentication for this reason. If you choose to ignore this warning and proceed with SQL Authentication, select OK. A similar message will be logged in the OCMC 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 the Credentials Info section, from the Credentials drop-down list, select the credentials for authentication.

   Note:
   - The Credentials drop-down is enabled only when the SQL Server Authentication type is selected. The Windows Authentication method uses the credentials of the user currently logged in, and disables the user name and password fields.
   - For standalone InTouch applications, the credentials are retrieved from the Application Manager. For managed InTouch applications, the credentials are retrieved from the Credential Manager of the Application Server. For more information, see Work with Credentials Manager in AVEVA™ InTouch HMI Application Development.

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

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

   2. Select 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.

6. Select Create to create the database, if required.

7. Select Test Connection to verify connectivity to the alarm database. A message indicates a successful connection to the database.

8. Select Next to configure which alarms to log. See Configure which alarms to log for detailed instructions.