IMPORTANT NOTES:
- These steps are known to work successfully; however, they have not been officially tested by Quest Software Quality Control.
- If any of these instructions are changed, this solution becomes unsupported by Quest Support and Development. For customization of the Quest MessageStats product, please contact our Professional Services Organization: http://wm.quest.com/services/services.asp.
To migrate to the MessageStats v6.0.1 database manually:
1. Launch SQL Server Management Studio.
2. Connect to the SQL Server that will 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 Script 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 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.
11. This should migrate all the tables and roles required.
12. Using SQL Server Management Studio locate the T_Configuration Table under the MessageStats database in Tables.
13. Right click the T_Configuration Table, select Open Table.
14. Change the following columns to:
Version = 6.0.0
Build = 6.0.0.289
Active = 1
15. Go to the Security\Logins folder in SQL Management Studio.
16. Confirm that the MessageStats Admin login has the following for database access: public, ddladmin and MessageStats_Admin.
17. Confirm that the MessageStats Web login has the following for database access: public and MessageStats_Web.
18. Close SQL Management Studio.
19. Confirm that the MessageStats v6.0.1 Console will connect by launching and confirming all settings.
