Configuring the Connection to the Alarm Database
- Last UpdatedMay 11, 2022
- 2 minute read
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.
To configure the connection to the alarm database
-
Right-click the Alarm Pareto control and then click Properties. The AlarmPareto Properties dialog box appears.
-
Click the Database tab.

-
Configure the connection. Do the following:
-
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.
-
In the Server Name box, enter the node name of the computer where the alarm database is installed.
-
In the Database Name box, type the name of the alarm database.
-
In the User box, type the name of a valid user account for the alarm database.
-
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.
-
-
Select the Auto Connect check box 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 check box, 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.
-
Click Test Connection to verify connectivity to the alarm database. A message indicates a successful connection.
-
Click Apply.