-
Title
How to manually update the MessageStats database on both clustered and non-clustered SQL 2005 and -
Description
How to manually update the MessageStats database on both clustered and non-clustered SQL 2005 and 2008 servers with the Windows Mobile 1.0.3 Report Pack SQL Scripts
-
Resolution
Download the Windows Mobile 1.0.3 SQL Scripts: \\prod\support\WM\Patches\SOL73184\WindowsMobile_1.0.3_SQL.zip
It is assumed that the Messagestats console and database has already been installed using the Messagestats documentation
1. Launch SQL Server Management Studio.
2. Connect to the SQL Server that is hosting 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. Unzip the attached SQL Scripts to the SQL Server where the MessageStats database resides.
6. Right click the MessageStats Database and select New Query.
7. After the Query window opens, select the File | Open | File.
8. Locate the WindowsMobile.sql SQL Script that was downloaded from this solution and open it.
9. Provide either Windows Authentication or SQL Server Authentication, click Connect.
10. Select the Query Menu and then Execute. (Select the MessageStats Database)
11. Repeat steps 9-10 for the WindowsMobileReports.sql SQL script
12. This will create all the tables and updates required for the Windows Mobile Report PackAfter completing the above steps on the SQL Server you will then need to run the Quest MessageStats Windows Mobile.exe on the Messagestats console machine.
1. Log onto the machine hosting the Messagestats console with the MessageStats service account
2. Run the Quest MessageStats Windows Mobile.exe.
3. When prompted to install features - Deselect the Database component.
4. Continue the installer specifying the SQL server that hosts the Messagestats Database.