I've just signed up to these forums in the hope someone can give me a quick word of advice with a SQL related issue I have.
I currently have Sql Server 2000 SP4 Standard edition running on a Windows Server 2003 R2 Enterprise edition SP2 server. I've been tasked with upgrading this server to Sql Server 2005 Enterprise edition and so I have created a replica of it isolated from our network.
Trouble is, when trialling an upgrade I get the message that my upgrade is blocked "because of edition upgrade rules. For more information see..."
So I've hunted through Sql Server 2005 Books online and have found a page on supported upgrade paths. It says I can go from Sql Server 2000 Standard Edition SP3 and later to SQL Server 2005 Enterprise Edition.
Does anyone know why I woud be receiving this error message?
I also tried to upgrade from EE/2000 to SE/2005 and could not do it. I ended up upgrading to Enterprise Edition/2005 and that worked. I would like to save the $$ as SE/2005 can use all the memory of the OS which is why we went with EE on this server in the 1st place...