Sentinel: How to upgrade from SQL 2000 to SQL 2005

This document contains screen shots on how to upgrade SQL Server 2000 to SQL Server 2005. Due to the confusion introduced by SQL Server 2005 (Yukon) installer, one common mistake one can make is NOT to update SQL Server Database Service 8.00.761 to 9.0.1399. The detail is described in step 12.

1. Start SQL Server 2005 installer and click InstallServer components, tools, Books Online, and samples

2. Check accept and click Next

3. Click Install

4. Click Next

5. Click next

6. Click next

7. Click next

8. Check all "check boxes”

9. Click Installed instances

10. Highlight SQL Server and click OK

11. Click Next

12. Make sure to check SQL Server Database Services 8.00.761

13. Click Next

14. Select "Use the built-in System account” and click Next

15. Use default, click Next

16. Click next

17. Click Install

19. Click Next

20. Click finish

21. Start SQL Server Management Studio. Check if it is running SQL Server 9.0.1399.