Security Groups are needed to assign rights to the database. Either Local or Global Groups can be used. They should be named MessageStats Admin and MessageStats Web but they can be named differently if needed.
***NOTE*** If the MessageStats database resides on a SQL cluster the Groups will have to be created in Active Directory.
- Launch Computer Management and expand System Tools | Local Users and Groups| Groups to create Local groups or launch Active Directory Users and Computers to create Global groups
- Create two groups one called MessageStats Admin (for accounts performing a gathering and administering the MessageStats console) and another called MessageStats Web (for accounts running reports)
Note: Make sure the MessageStats service account is added to the MessageStats Admin group
Note: The ‘Everyone’ group is typically added to the MessageStats Web group
To assign the MessageStats Admin group to the MessageStats database:
- Launch SQL Management Studio
- Expand Security | Logins
- Right click on Logins and choose New Login
- Click on search and find the MessageStats Admin group
- Click OK
- Select Windows Authentication
- For ‘Default Database’ choose MessageStats from the drop down
- In the left hand column click on User Mapping
- For the “Users Mapped to this Login” section put a check mark in the box beside the MessageStats database
- Under the “Database role Memberships for” section select:
- Public
- MessageStats_Admin
- db_Owner
- Click OK
To assign the MessageStats Web group to the MessageStats database:
- Launch SQL Management Studio
- Expand Security | Logins
- Right click on Logins and choose New Login
- Click on search and find the MessageStats Web group
- Click OK
- Select Windows Authentication
- For ‘Default Database’ choose MessageStats from the drop down
- In the left hand column click on User Mapping
- For the “Users Mapped to this Login” section put a check mark in the box beside the MessageStats database
- Under the “Database role Memberships for” section select:
- Public
- MessageStats_web
- Click OK