Microsoft SQL Server

To add Data Source for Microsoft SQL Server:

1. Launch AVEVA Integration Service web administrator. For example, <https://integration service server host name>/.

2. Click Add Data Source.

   

3. In the Name text box, specify the name for the data source.

   Note: The data source name must be unique and must not contain special characters other than _ (underscore), - (hyphen), and space.

4. From the Product drop-down list, select the product SQL Server.

   

5. Select the authentication option from Authentication drop-down list.

   1. To connect using Windows authentication, select Windows Authentication.

   2. To connect using SQL Server Security, select SQL Server Authentication.

      

6. Provide the Server details and select the desired MDB/Database (you may have to specify the User Name and Password if authentication type is SQL Server Authentication)

   

7. Click Test Datasource.

   If all inputs provided are valid, a success message is displayed.

   

8. Click OK.

9. Click Save.

   The data source is saved, and a success message is displayed.