levitymn


I am upgrading a sql server 2000 with sp4 (I have double and triple checked the sp) on a windows 2003 sp1 server and I keep getting the following error:

Name: Microsoft SQL Server 2000
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.


I cannot find anything saying that I need any other service pack other than sp4 for sql serer 2000. Any one ever run into this or have a clue what might be causing the installer to think I have the wrong service pack



Re: SQL 2000 SP4 to SQL 2005 upgrade blocked.

Milos Cimfl - MSFT


One possible upgrade block can be different editions for example you cannot upgrade from Entreprise editon to Standard. Can you check both editions the installed SQL Server 2000 and new one SQL Server 2005.

Another problem can be language. For upgrade from SQL 2000 both products need to be the same language.







Re: SQL 2000 SP4 to SQL 2005 upgrade blocked.

levitymn

Both are SQL Server Standard Both are english. I cannot find any difference between the original install and the one I am trying to upgrade to.





Re: SQL 2000 SP4 to SQL 2005 upgrade blocked.

Satya SKJ

Check the edition of SQL Server 2000 you are trying to ugrade.

Run @@servername and post the results.