Add users to the roles

When you run the Database script after the upgrading or installing the application, two roles are generated by default, MorServerRole and IntelaTracRole. You need to now create two users and assign one user to each role. The user assigned to MORServerRole should only be used in Username field of the DataServer and Identity Provider in the Configurator for database configuration. The user assigned to IntelaTracServerRole should only be used in Username field of the Client and Server installation.

Steps:

1. Connect to the database in SQL Server Management Studio.

2. Add a user to MORServerRole by doing the following steps:

   1. In the Object Explorer pane, expand the Security folder, and select Logins.

   2. Right-click and select New Login.

      The Login-New window appears. In the Select a page section, General is selected and the fields appear in the right side of the pane

   3. In the Login name field, enter the name of a SQL Server user (for example: IntelaTracMORUser).

   4. Select SQL Server Authentication radio button and set a password.

   5. Clear the check box Enforce password policy.

   6. In the Default database field, select the default database (for example: IntelaTrac).

   7. From the Select a page section, select Server Roles,and then select the public check box.

   8. From the Select a page section, select User Mapping, and select the database from the Users mapped to this login section.

   9. Select the following roles from the Database role membership for and then select OK.

      • db_datawriter

      • db_datareader

      • MORServerRole

3. Repeat the steps provided in Step 2 to add a user to 'IntelaTracRole'.

   In sub-step (i), you have to select the following roles:

   • db_datawriter

   • db_datareader

   • IntelaTracRole

4. In the Object Explorer pane, expand the Databases folder and select the database.

5. In the database folder, select Security, and then select Users.

6. Right-click and select New User.

   The Database User window appears.

7. Enter the User name, and in the Login name, browse and select the role that you want to assign to the user.

8. Select OK.

What's Next?

• See the topic WorkFlow to install or upgrade to AVEVA Mobile Operator for the next steps.