SQL Server Security

By default, AVEVA Instrumentation uses Windows Authentication to allow users access to AVEVA Instrumentation databases on a SQL Server. To enable users to access each AVEVA Instrumentation database, the SQL Server Administrator must add each user login to the database and allocate them to a role named ‘Users’, which gives these Users permissions to access AVEVA Instrumentation database objects. This is performed using Instrumentation Security Manager.

Alternatively, add a User’s Windows Domain name to the SQL Server database with a ‘Users’ role.To do this:

1. In Instrumentation Security Manager, select the Project > Add New User to SQL Server Project option.

   A window enabling login as SQL Server administrator displays.

2. After entering the Server Name and Database Name (and either logging in using Windows Authentication or logging in with Admin User name and password), this window will be displayed:

   

3. Select the Project databases to add the new user to.

4. Enter the User Domain Login Name.

5. Select required Access Rights (Read-Write or Read-Only).

6. Then click Save to add the user to the databases.

7. Repeat this procedure for all new users.