Create a SQL Server Database and Login

You must create an empty database in Microsoft SQL Server and a login for both AVEVA NET Gatekeeper and AVEVA Change Manager and also a separate empty Naming-and-Numbering database and a login by using SQL Server Management Studio.

Note: You must also select the Mixed mode security authentication mode for the Database Engine by using Microsoft SQL Server Management Studio. Mixed mode enables both Windows Authentication and SQL Server Authentication.

To open SQL Server Management Studio:

1. On the Start menu, point to All Programs, point to Microsoft SQL Server and click SQL Server Management Studio.

2. In the Connect to Server dialog box, verify the default settings, and then click Connect. To connect, the Server name box must contain the name of the computer where SQL Server is installed.

Create a Database

To create an empty database using Microsoft SQL Server Management Studio:

3. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

4. Right-click Databases, and then click New Database.

5. In New Database, enter one of the following names in the Database name box:

   • Gatekeeper

   • ChangeManager

   • NandN

6. Click OK to create the database.

7. Repeat steps 2, 3 and 4 to create the other database.

Create a Login

To create a SQL Server login by using Microsoft SQL Server Management Studio:

8. In Object Explorer, expand the folder of the server instance in which you want to create the new login.

9. Right-click the Security folder and then click New Login.

10. In the Login – New dialog box, on the General page, enter dba_user in the Login name box.

11. Select SQL Server authentication, to create a login that is saved on a SQL Server database:

    • In the Password box, enter a password for the new user. Enter that password again into the Confirm Password box.

    • Clear Enforce password policy. Enforce password policy is selected by default when SQL Server authentication is selected.

12. From the Default database list, select the database you entered while creating an empty database.

13. From the Default language list, select English.

14. On the User Mapping page, modify the mapping of logins to database users:

    • 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 specified database.

      Notes:

      • Select the dba_user role to create a business user.

      • Select the db_owner role to create a user with the administrator privileges.

15. Click OK.