SQL Server Security

By default, AVEVA Electrical uses Windows Authentication to allow users access to AVEVA Electrical databases on a SQL Server. To enable users to access each AVEVA Electrical 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 Electrical database objects. This is performed using the Electrical Security Manager.

Alternatively, add a user’s Windows Domain name to the SQL Server database with a ‘Users’ role.

In Electrical Security Manager, select the Project > Add New User to SQL Server Project option. This displays a window enabling login as SQL Server administrator.

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:

Select the project database(s) to add the new user to.

Enter the User Domain Login Name.

Select required Access/Rights (Read-Write or Read-Only)

Then click Save to add the user to the database(s)

Repeat this procedure for all new users.