Messagestats can connect to multiple Notes Migrator for Exchange Databases. Repeat the steps below to connect to exchange Notes Migrator Database.
When running reports in Messagestats under Notes Migration, use the Notes Migrator Database filter in each report to see statistics on your different Notes Migrations.
Connecting to a Notes Migrator Database.
Certain reports can be used to assess the progress of a Notes to Exchange migration. By connecting to a Notes Migrator for Exchange database, you can
view data in the following real-time reports:
,
Migration Status per Collection
Migration Status per Server
Mailbox Comparison
Distribution List Provisioning
NSF Status
,
You can connect to a Notes Migrator database that is on the same SQL instance as the MessageStats database, or to a remote Notes Migrator database on a different SQL server. If you connect to a remote database, you must use SQL authentication to create a linked server connection.
,
To connect to a Notes Migrator database:
1. Expand the Lotus Notes node and select Notes Migrator Databases in the treeview.
2. Right-click and select Connect.
3. Enter a descriptive name for the connection. This is the name used to identify the database in the Notes Migration Status reports.
,
Note: If you are connecting to a Notes Migrator database on the same SQL instance as the MessageStats database, you can select Windows Authentication and proceed to Step 6.
,
Note: If you are connecting to a Notes Migrator database on a different SQL server, you must select SQL Authentication.
,
4. Select the type of authentication for the database connection:
a.) Enter the SQL user name and password that will be used to connect to the database. The SQL account must have the following database role memberships:
public
db_datareader
,
5. Select the SQL server that contains the Notes Migrator database.
6. Select the Notes Migrator database that contains the migration data.
7. Click Test Connection to verify that the connection can be established.
8. Click Save.
,
If the MessageStats Database and Notes Database are on the same SQL server you will need to make sure that the SQL Account that is being used for the MessageStats reports (In the QMSReports.udl file) has db_datareader access to the Notes Database.
,
The Windows account that is used to run the MessageStats console must be a member of the SQL setupadmin fixed server role on the remote SQL server that hosts the MessageStats database. Only members of the setupadmin fixed server role have sufficient rights to create a linked server.
