Environment
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.
Situation
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.
Start SQL Server 2005 installer and click InstallServer components, tools, Books Online, and samples
Check accept and click Next
Click Install
Click Next
Click next
Click next
Click next
Check all "check boxes”
Click Installed instances
Highlight SQL Server and click OK
Click Next
Make sure to check SQL Server Database Services 8.00.761
Click Next
Select "Use the built-in System account” and click Next
Use default, click Next
Click next
Click Install
Click Next
Click finish
Start SQL Server Management Studio. Check if it is running SQL Server 9.0.1399.