SQL Server Setup

Note:
SQL Server Administration rights are required for AVEVA Electrical 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.

The SQL Server Login window is displayed when the button next to the SQL Server Name field on the Create a New AVEVA Electrical Project window is pressed (refer to Creating a New Project). This is used to create the new project database on a selected SQL Server.

Enter a valid Server Name.

Login using Windows Authentication or SQL Server Authentication. This login must be a valid SQL Server Administrator account login.

Important:
Do not use the AVEVA Electrical Admin login.

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

Clicking OK will run a script to create the new AVEVA Electrical database.

AVEVA Electrical Admin Account

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

Manual AVEVA Electrical SQL Server Database Creation

The above window runs a script named ‘EmptySQLDb.exe’ located in the AVEVA Electrical program files folder ‘EmptyDbs’ (typically: ‘c:\program files\AVEVA\ Electrical12.2\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 the Admin account exists and has ‘dbo’ rights to the new database. Contact AVEVA to request the password for this account.