Configure the database connection

You must select a database to restore the archived data to. If the specified database is not present on the server, you are prompted to create a new database with default server parameters.

Configure a database for restoring archived data

1. Open the Alarm DB Restore utility. Do the following:

   1. In the Tools view, expand Applications.

   2. Double-click Alarm DB Restore.

2. Select the Configuration tab.

   

3. Configure the connection to the alarm database. 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, select OK. A similar message will be logged in the Log Viewer.

   2. In the SQL Server Name list, select the node name of the server that hosts the alarm database.

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

   4. In the Credentials Information area, from the Credentials drop-down, select the credentials of alarm database for authentication.

      The Credentials field is enabled only when you select SQL Server authentication type. The Windows Authentication method uses the credentials of the user currently logged in, and disables the Credentials field.

   Note: 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.

   1. Select Test Connection to test your connection to the database. A message indicates whether the connection to the alarm database is successful or not.

   2. Select OK.

4. Select Close.