How to manually upgrade to version 6.5.1 Database on both clustered and non-clustered SQL 2000 &a (4344863)

How to manually upgrade to version 6.5.1 Database on both clustered and non-clustered SQL 2000 & SQL 2005 Servers

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.5.1 database manually:

SQL 2005

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 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. (Select the MessageStats Database)

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.5.1
Build = 6.5.1.1276

Active = True

and then close the Table.

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. Upgrade the MessageStats Scheduler (Console) and Web reports to 6.5.1

20. Confirm that the MessageStats v6.5.1 - Console will connect by launching and confirming all settings

SQL 2000

1. Launch SQL Enterprise Manager.

2. Expand SQL Server Name.

3. Expand Databases.

4. Unzip the attached SQL Script to the SQL Server where the MessageStats database resides.

5. In SQL Enterprise Manager select the MessageStats Database.

6. From the Tools menu select SQL Query Analyzer

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. Make sure that the MessageStats database is selected in the drop down menu above the window.

10. Select the Query Menu and then Execute.

11. This should migrate all the tables and roles required.

12. Using SQL Enterprise Manager locate the T_Configuration Table under the MessageStats database in Tables.

13. Right click the T_Configuration Table, select Open Table | Return All Rows

14. Change the following columns to:

Version = 6.5.1
Build = 6.5.1.1276

Active = True

and then close the Table.