Chat now with support
Chat with Support

MessageStats 7.8.1 - Reports User Guide

Upgrading MessageStats Overview Typical MessageStats Upgrade Scenarios Moving the MessageStats Database Moving and Upgrading MessageStats Moving Custom Reports and Report Subscriptions Viewing, Creating, and Editing MessageStats Reports My Reports and Corporate Reports Exchange Executive Summaries Reports Exchange Organizations Reports Exchange Server Reports Exchange Content Analysis Reports Exchange Mailboxes Reports Exchange Mail Contacts Reports Exchange Distribution Groups Reports Exchange Public Folders Reports Exchange Storage Reports Exchange Internet Reports Exchange Inventory Reports Migration Reports MessageStats Gathering Reports Appendix A: How to Read the Reports Report Filter Definitions

Setting Security on the New SQL Server

Security groups are needed to assign rights to the MessageStats database on the new SQL server. You must create two groups, either local groups or global groups, named MessageStats Admin and MessageStats Web.

If the MessageStats database resides on a SQL cluster, create the groups in Active Directory.

To create the MessageStats groups
1
Add the MessageStats service account to the local Administrators group on the new SQL server.
2
Create two groups called MessageStats Admin and MessageStats Web.
•
The MessageStats Admin group is used for accounts that perform a gathering and administer the MessageStats console.
•
The MessageStats Web group is used for accounts that render the reports.
3
Add the MessageStats service account to the MessageStats Admin group.
4
Add Everyone to the MessageStats Web group.
To assign the MessageStats Admin group to the MessageStats database
1
Open SQL Server Management Studio and expand Security | Logins.
2
Right-click Logins and select New Login.
3
Click Search and find the MessageStats Admin group. Click OK.
4
Select Windows Authentication.
If the database and reports are on separate servers, SQL authentication is recommended. See If SQL Authentication is Used .
However, if Windows Authentication is required, you must set up Kerberos delegation from the MessageStats Reports server to the MessageStats Database server. For more information, see the section titled “Deploying a Distributed Installation Using Windows Authentication” in the MessageStats Deployment Guide.
5
For the Default Database, select MessageStats from the drop-down list.
6
In the left hand column, click User Mapping.
7
In the Users Mapped to this Login section, select check box beside the MessageStats database.
8
Under Database role memberships for, select the following roles for membership:
•
Public
•
MessageStats_Admin
•
db_securityadmin
•
db_ddladmin
9
Click OK.
To assign the MessageStats Web group to the MessageStats database
1
Open SQL Server Management Studio and expand Security | Logins.
2
Right-click Logins and select New Login.
3
Click Search and find the MessageStats Web group. Click OK.
4
Select Windows Authentication.
If the database and reports are on separate servers, SQL authentication is recommended. See If SQL Authentication is Used .
However, if Windows Authentication is required, you must set up Kerberos delegation from the MessageStats Reports server to the MessageStats Database server. For more information, see the section titled “Deploying a Distributed Installation Using Windows Authentication” in the MessageStats Deployment Guide.
5
For the Default Database, select MessageStats from the drop-down list.
6
In the left column, click User Mapping.
7
In the Users Mapped to this Login section, select check box beside the MessageStats database.
8
Under Database role memberships for, select the following roles for membership:
•
Public
•
MessageStats_Web.
9
Click OK.
If SQL Authentication is Used

If SQL authentication is being used, you must create a SQL account on the new SQL server and assign the appropriate database roles.

Assign the following database roles to the new SQL account:

•
Public
•
Messagestats_Web
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating