Skip to main content
EMS Software, LLC

Configuring 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.  Add the db_datareader and db_datawriter roles.   
3.    Repeat Step 2 for the EMS_Master database. 
4.    Using Microsoft SQL Server Management Studio, execute the following statement against your EMS database: 

sp_addrolemember 'EMS_Role', 'securitygroup'  

Note: Replace securitygroup with the name of your EMS Active Directory security group. 

5.    Repeat Step 4 for the EMS_Master database.