SQL Server Performance

can we upgrade an evaluation edition of sql server 2005 having SP2 to enterprise edition?

Discussion in 'SQL Server 2005 Clustering' started by gpreddy, Sep 3, 2008.

  1. gpreddy New Member

    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

  2. moh_hassan20 New Member

    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]


  3. gpreddy New Member

    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
  4. moh_hassan20 New Member

    [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
  5. gpreddy New Member

Share This Page