Microsoft SQL Server

To configure AVEVA™ Integration Service (Service) for Microsoft SQL Server:

1. Start Integration Settings Editor.

2. For the Select Product list, select SQL Server.

3. Click Add Configuration.

   Note: If you have logged on using a Local System account, you will be prompted to log on using a Service account. For information on how to log on using a Service account, see Changing to a Service Account.

4. On the Select SQL Server dialog box, provide the location or the name of database in the SQL Server box..

   

5. Provide the login credentials to log on to the database. If you want to use the Windows authentication, select the Use Windows Integrated Security (Windows Authentication) option. Else, select the Log in as Administrator with password (SQL Server Security) option and provide the username and password of the Administrator.

6. Click Connect to Server.

7. After the connection to the Server is successful, select the required SQL sever database from the Select Database list, and then click OK.

8. After the message that the connection is successful is displayed, click OK.

9. After the database is added to the Integration Settings Editor window, click Save.