Chat now with support
Chat with Support

NOTICE! We are upgrading our support telephone services, implementing Genesys, starting the week of May 26, 2025

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

1b. Manually Upgrading the MessageStats Database on a Separate Server

In some situations, you might need to manually upgrade the MessageStats database using a script instead of using the MessageStats installer.

To migrate the MessageStats database manually, you use a SQL script called MessageStatsMigration.sql that is located in the MessageStats installation directory in a folder named SQL.

To manually migrate the MessageStats database
1
Copy the MessageStatsMigration.sql file to the SQL server on which the MessageStats database resides.
2
Open SQL Server Management Studio.
3
Connect to the SQL Server that is hosting the MessageStats Database.
Server Type = Database Engine
Server Name = SQL Server Name
Authentication = Windows Authentication or SQL Server Authentication
SQL Authentication is recommended for installations in which the reports and database are on separate servers.
4
Expand SQL Server Name and expand Databases.
5
Right-click the MessageStats database and select New Query.
6
On the Query window, select File | Open | File.
7
Locate the MessageStatsMigration.sql script file and open it.
8
Provide either the Windows Authentication or SQL Server Authentication and click Connect.
9
Select the Query Menu and Execute. Select the MessageStats Database.
This migrates the tables and roles as required.
10
Go to the Security\Logins folder in SQL Management Studio.
11
Confirm that the MessageStats Admin login has the following roles for database access:
•
public
•
db_ddladmin
•
db_securityadmin
•
MessageStats_Admin
12
Confirm that the MessageStats Web login has the following roles for database access:
•
public
•
MessageStats_Web
13
Close SQL Management Studio.
14
Upgrade the MessageStats reports and server (scheduler service). For details, see 2. Upgrading the MessageStats Reports and the MessageStats Server .
15
Confirm that the MessageStats console can connect by opening and confirming all settings.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating