SQL Server Setup

Note: SQL Server Administration rights are required for AVEVA Instrumentation to create the SQL Database. The Server Name is also required.
Login information is not saved anywhere and is used once to connect to the Server to create the Database.

1. The SQL Server Login window is displayed when the button next to the SQL Server name field on the Create a New AVEVA Instrumentation Project window is pressed. This is used to create the new Project Database on a selected SQL Server. For further information, refer to Create a New Project.

   

2. Enter a valid server name. Log in using Windows Authentication or SQL Server Authentication. This login must be a valid SQL Server Administrator account login.

   Note: Do not use the AVEVA Instrumentation Admin login.

3. Test that the entered details are valid by clicking Test Connection.

4. Clicking OK will run a script to create the new AVEVA Instrumentation Database.

AVEVA Instrumentation Admin Account

The AVEVA Instrumentation SQL Database creation script creates a special AVEVA Instrumentation Admin account for the Database with ‘dbo’ rights on the Database. This account is used by AVEVA Instrumentation to enable future updates and upgrades for the Database.

Manual AVEVA Instrumentation SQL Server Database Creation

The above window runs a script named ‘EmptySQLDb.exe’ located in the AVEVA Instrumentation program files folder ‘EmptyDbs’ (typically: ‘C:\program files\AVEVA\ Instrumentation12.3\EmptyDbs’).

This file can also be run manually if a User has SQL Admin rights. However, if this file is run manually, then the SQL Administrator should ensure that the Admin account exists and that it has ‘dbo’ rights to the new Database.

Contact AVEVA Instrumentation to request the password for this account.