Configure the connection to the alarm database

You must configure the connection between the Alarm Pareto control and the alarm database.

It is good practice to use an account with appropriate read-only access to the alarm database and not a system administrator account.

Configure the connection to the alarm database

1. Right-click the Alarm Pareto control and then select Properties.

   The AlarmPareto Properties dialog box appears.

2. Select the Database tab.

   

3. Configure the 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 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 Name box, type the name of the alarm database.

   4. From the Credentials drop down, 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 Credential Manager in AVEVA™ InTouch HMI Application Development.

4. Select the Auto Connect checkbox if you want the Alarm Pareto control to automatically connect to the alarm database as soon as WindowViewer starts up.

   If you don’t select the Auto Connect checkbox, you must configure the Alarm Pareto control to connect to the alarm database by explicitly calling the Connect() method. For more information about the Connect method, see Connect() Method.

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

6. Select Apply.