Manual Creation of SQL Server Database

Caution: If you are upgrading AVEVA Information Standards Manager and you want to maintain your existing data, DO NOT create a new database, skip this section and go to Upgrading an Existing Installation.

You can manually perform the process based on the following information:

Step 1 - To create a new SQL Server database:

1. Log on to your Database Server machine and open SQL Server Management Studio.

2. In Object Explorer, expand an instance of the SQL Server Database Engine.

3. Right-click Databases, then click New Database.

4. In the Database window, type ISM or another suitable Database Name.

5. Select an Owner if you do not want to use the default.

6. For the Logical Name of the primary data file, type ISM.

7. For the Logical Name of the transaction log file, type ISM_log, then click OK.

   

   Note: Make sure to note the Database name, as you will need to use the same name later.

For AVEVA Information Standards Manager to fully manage the database, you need to create two kinds of users:

• A standard user - Used for all standard operations and procedures.

• An admin user - Used for operations and procedures that require a higher security clearance.

Step 2 - To create a standard user:

8. On the General page, match the information in the following image:

   

9. On the User Mapping page, match the information in the following image:

   

Step 3 - To create an admin user:

10. On the General page, match the information in the following image:

    

11. On the User Mapping page, match the information in the following image:

    

You need to run the AVEVA Database Script using the name of your newly created database.

Step 4 - To run the script:

12. In the AVEVA Information Standards Manager installer, go to the Database folder within the Files folder, and open AVEVA ISM v2.2.0 MS SQL Server Initialize Empty Database.sql.

13. Above the first go statement, type use <database name>, where <database name> is the name of the database you created.

    Note: For information on how to create a database, see Step 1 of Manual Creation of SQL Server Database.

14. To grant permission to administrator users, find and replace three occurrences of '$(ismAdministrator)' with a username that has administrator privilege (See Notes). To grant permission to standard users, find and replace two occurrences of '$(ismUser)' with a username that has standard user privilege (See Notes). For example, replace ['+$(ismAdministrator)+'] with ['+'ISM_Admin'+'], and ['+$(ismUser)+'] with ['+'ISM_User'+'].

    Notes:

    • For information on how to create an administrator user, see Step 3 of Manual Creation of SQL Server Database.

    • For information on how to create a standard user, see Step 2 of Manual Creation of SQL Server Database.

15. Run this script.

Step 5 - To assign a schema to the users:

16. For the standard user, on the User Mapping page, set Default Schema to ISM.

    

17. For the admin user, on the User Mapping page, set Default Schema to ISM.