How to Configure the Archive Manager Report Pack after it has been installed and what are the Permissions needed?
Required Permissions:
Installation Rights
The following rights are required to install the report pack:
1. Local Administrator rights on the MessageStats server the Archive Manager Report pack is being installed on.
2. MessageStats Admin rights on the server that houses the MessageStats database
Follow the steps below to configure the Archive Manager Report Pack
Before you create your Archive Manager gathering task, you must set up a connection to each of the Archive Manager database instances from which you want to gather information. As part of the connection definition, you need a user account that has full SQL administrator rights on the Archive Manager SQL database. After you have created connections to the Archive Manager databases, you create a gathering task to collect information from the databases.
Setting Connections to Archive Manager
As part of the initial configuration for the report pack, you must set up a connection to any Archive Manager SQL database instances from which you want to retrieve data. When you set up the initial connection to the Archive Manager SQL database, you specify a user account and password of an SQL account. The user account is required for those reports which require direct access to the Archive Manager database. The account must have SQL administrator rights to the server that hosts the database.
To connect to an Archive Manager SQL database
1. Navigate to the Archive Manager node, right-click and select Connect.
2. Enter the name of the server that hosts the Archive Manager database.
3. Click Browse button beside the Archive Manager SQL Connection string box. The Data Link Properties dialog is displayed. On this dialog, you define the OLE provider type for the data and also specify the user account that is to be used to directly access the Archive Manager database for real-time reports.
4. Select Microsoft OLE Provider for SQL Server as the type data to which you are connecting
5. Click Next
6. Enter the server name for the Archive Manager SQL server.
7. Click Use a specific user name and password and enter a user name and password for an SQL account that has full SQL administrator rights on the Archive Manager database server. The account that is used to connect to the Archive Manager SQL database must have the following database role memberships:
• public
• db_datareader
8. Click Select the database on the server and select the Archive Manager SQL database name.
NOTE: SQL Authentication must be enabled on the server on which the Archive Manager report pack is installed and on the Archive Manager SQL server to which you are connecting.
9. Click OK.
10. If you want, you can change the value for the default Archive Mailbox Quota.
This value is used by the Archive Mailboxes Over Quota report to identify mailboxes that exceed the value that is specified here.
11. Click OK.
The Archive Manager servers to which you are connected are displayed under the Archive Manager treeview in the MessageStats console.
