AVEVA NET Gatekeeper and AVEVA Change Manager

Create EDW Pre-Processor SQL Server Database and Login

Save PDF

Save PDF

Use Microsoft SQL Server Management Studio to create an empty database in Microsoft SQL Server and a login for EDW Pre-Processor.

Note: Select Mixed mode security authentication mode for the Database Engine.

To create an empty database:

In Object Explorer, connect to an instance of the SQL Server Database Engine, then expand the instance tree.
Right-click Databases, then click New Database.
In New Database, enter the name of the database, for example, PreProcessor, in Database.
To create the database, click OK.

To create a SQL Server login:

In Object Explorer, expand the folder of the server instance in which you want to create the new login.
Right-click Security, then click New Login.
In the Login – New dialogue box, on the General tab, enter a name for the EDW Pre-Processor Database Owner user in the login name.
Select SQL Server authentication, to create a login that is saved on a SQL Server database.
Enter a password in Password. Input the same password again in Confirm Password.
Clear the check box for Enforce password policy.
From the Default database list, select the database you entered while creating an empty database.
From the Default language list, select English.
On the User Mapping page, modify the mapping of logins to database users as follows:
- For users mapped to this login, select the database name that this login can access.
  Note: Select the same database you entered while creating an empty database.
- For Database role membership for <database name>, select the db_owner role for the user in the database.
Click OK.