Configure EMS Database

To configure your EMS Database:

  1. Using Microsoft SQL Server Management Studio, add a login for the EMS Active Directory security group.

  2. Under the User Mapping area, map the login to your EMS database.

  3. Add the db_datareader and db_datawriter roles.

  4. Repeat Step 2 for the EMS_Master database.

  5. Using Microsoft SQL Server Management Studio, execute the following statement against your EMS database:

    sp_addrolemember 'EMS_Role', 'securitygroup'

  6. Rename the securitygroup with the name of your EMS Active Directory security group.

  1. Repeat Step 5 for the EMS_Master database.