Hi, Iam upgrading enterprise evaluation x-64 to enterprise edition-x64 in Active/Passive cluster environment. The upgrade works fine with RTM version of enterprise evaluation edition to enterprise edition, But when the evaluation edition has SP2 installed on it and then upgrading to enterprise edition it shows upgrade is blocked there are no features to upgrade. Like exactly as below: Name: SQLDBAINS1 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. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Name: Microsoft SQL Server 2005 Tools (64-bit) 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. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Here is message at the end of the setup wizard... TITLE: Microsoft SQL Server Setup ------------------------------ None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel. So we can not upgrade an evaluation edition having SP2 to enterprise edition? Thanks
run SELECT SERVERPROPERTY('ProductVersion') available versions for sql 2005 are: 9.00.1399 : SQL Server 2005 (RTM initial version) 9.00.2047: SQL Server 2005 SP1 9.00.3042: SQL Server 2005 SP2 SP2 is the highest version for same RTM version(9.00.1399 ) : you can upgrade from one edition to other based on senarios of product, review: http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx so , as you said: [quote user="gpreddy"]So we can not upgrade an evaluation edition having SP2 to enterprise edition?[/quote]
Thank you Hassan, The sql server version Iam upgrading is 9.00.3042: SQL Server 2005 SP2(SQL Server 2005 Enterprise evaluation x-64). In the link http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx SQL Server 2005 Evaluation Edition1,2SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition SQL Server 2005 Express Edition They did not mentioned whether we can upgrade SQL Server 2005 Evaluation Edition with SP2 to SQL Server 2005 Enterprise. So Iam just wanna make sure that 'We can not upgrade SQL Server 2005 Evaluation Edition with SP2 to SQL Server 2005 Enterprise'. correct me if I understand wrong. Thanks
[quote user="gpreddy"] So Iam just wanna make sure that 'We can not upgrade SQL Server 2005 Evaluation Edition with SP2 to SQL Server 2005 Enterprise'. correct me if I understand wrong. [/quote] yes, you are right. you can not upgrade SQL Server 2005 Evaluation Edition with SP2 to SQL Server 2005 Enterprise