-
Title
How to manually create the groups used by the Messagestats database. -
Description
How to manually create the groups used by the Messagestats database.
-
Resolution
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.
Note: If the MessageStats database resides on a cluster the Groups will have to be created in Active Directory.
1. 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.
2. 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. The Everyone group is typically added to the MessageStats Web group.
To assign the MessageStats Admin group to the MessageStats database:
1. Launch SQL Management Studio and expand Security | Logins
2. Right click on Logins and choose New Login.
3. Click on search and find the MessageStats Admin group. Click OK.
4. Select Windows Authentication.
5. For Default Database choose MessageStats from the drop down.
6. In the left hand column click on User Mapping.
7. For the Users Mapped to this Login section put a check mark in the box beside the MessageStats database.
8. Under the Database role Memberships for section select Public, MessageStats_Admin, db_securityadmin and db_ddladmin. Click OK.
Â
To assign the MessageStats Web group to the MessageStats database:
1. Launch SQL Management Studio and expand Security | Logins
2. Right click on Logins and choose New Login.
3. Click on search and find the MessageStats Admin group. Click OK.
4. Select Windows Authentication.
5. For Default Database choose MessageStats from the drop down.
6. In the left hand column click on User Mapping.
7. For the Users Mapped to this Login section put a check mark in the box beside the MessageStats database.
8. Under the Database role Memberships for section select Public, and MessageStats_web. Click OK.