How to manually create the MessageStats Database on both clustered and non-clustered SQL Servers. (4225694)

Please copy the MessageStats Database Script (MessageStatsDatabase.sql) from the SQL folder in your MessageStats Installation package to your SQL server.

IMPORTANT NOTES:

- These steps are known to work successfully; however, they have not been officially tested by Quest Quality Control.

- If any of these instructions are changed, this solution becomes unsupported by Quest Support and Development. For customization of the Quest MessageStats product, please contact our Professional Services Organization: https://support.quest.com/professional-services-product-select/

To manually create the database:

1. Launch SQL Server Management Studio
2. Connect to the SQL Server which is going to host the MessageStats Database (for example, Server Type = Database Engine, Server Name = SQL Server Name and Authentication = either Windows Authentication or SQL Server Authentication
3. Expand SQL Server Name
4. Expand Databases
5. Create an empty database called MessageStats by right clicking the Databases and selecting New Database
6. Right click the newly created MessageStats Database and select New Query
7. After the Query window opens, select the File | Open | File
8. Locate the "MessageStastsDatabase.sql" SQL Script from the SQL folder of your MessageStats Installation Media and open itt
9. Select the Query Menu and then Execute
10. This will create all the tables and roles required

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 SQL 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
***NOTE*** 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 Web 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