locked
There are no features selected for upgrade RRS feed

  • Question

  • We're going to migrate our database server from windows server 2003 to windows server 2008 r2 , we setup a windows 2008 r2 64bit server then installed sql server 2005 32bit  and make sure that our applications are working on new environment .

    The second step is to upgrade sql server 2005 32bit to sql server 2008 r2 64bit we ran the advisor and got warnings to be done after installation, and when when run installation and get into the Select Feature step we keep getting a grayed out and cannot select a feature to upgrade.

    try to uninstall sql as in KB http://support.microsoft.com/kb/955399 

    but error raised

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2>setup
    /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine
    Microsoft (R) SQL Server 2008 R2 Setup 10.50.1600.01
    Copyright (c) Microsoft Corporation.  All rights reserved.

    The following error occurred:
    No feature were uninstalled during the setup execution. The requested features m
    ay not be installed. Please review the summary.txt logs for further details.

    Error result: -2068643838
    Result facility code: 1203
    Result error code: 2

    Please review the summary.txt log for further details

     

    full details

     

    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2068643838
      Exit facility code:            1203
      Exit error code:               2
      Exit message:                  No feature were uninstalled during the setup execution. The requested features may not be installed. Please review the summary.txt logs for further details.
      Start time:                    2011-01-25 11:42:57
      End time:                      2011-01-25 11:43:47
      Requested action:              Uninstall

    Machine Properties:
      Machine name:                  MOSS2010
      Machine processor count:       8
      OS version:                    Windows Server 2008 R2
      OS service pack:              
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        Database Engine Services                 1033                 Enterprise Edition   9.3.4035        No       
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        SQL Server Replication                   1033                 Enterprise Edition   9.3.4035        No       
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        SharedTools                              1033                 Enterprise Edition   9.3.4035        No       
      Sql Server 2005                                                          Tools                                    1033                 Enterprise Edition   9.3.4035        No       
      Sql Server 2005                                                          ToolsClient                              1033                 Enterprise Edition   9.3.4035        No       
      Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Enterprise Edition   9.3.4035        No       

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation edition:          EVAL

    User Input Settings:
      ACTION:                        Uninstall
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110125_114242\ConfigurationFile.ini
      ENU:                           True
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                     
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  <empty>
      PASSPHRASE:                    *****
      QUIET:                         True
      QUIETSIMPLE:                   False
      UIMODE:                        Normal
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110125_114242\ConfigurationFile.ini

    Detailed results:

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110125_114242\SystemConfigurationCheck_Report.htm

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException
        Message:
            No feature were uninstalled during the setup execution. The requested features may not be installed. Please review the summary.txt logs for further details.


    DayAfterTomorrow
    Tuesday, January 25, 2011 9:53 AM

Answers

All replies

  • Hello,

    Try to uninstall SQL Server 2005 manually using the following article:

    http://support.microsoft.com/kb/909967  

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, January 25, 2011 10:55 AM
  • uninstalling sql server 2005 , then install new sql server 2008 r2 , then restore our databases backup from sql 2005 enterprise server to r2, is this the correct path to do it? because we're dealing with two different servers the old windows 2003 & sql server 2005 and the new server 2008 r2 and sql 2008 r2
    DayAfterTomorrow
    Tuesday, January 25, 2011 3:05 PM
  • Hello,

    If you are no performing an “in-place” upgrade, you are not upgrading a SQL Server 2005 instance to SQL Server 2008 R2 on the same server, then transfer databases from one server to another using detach/attach or backup/restore, transfer logins, jobs and packages.

    The following articles may help:

    http://support.microsoft.com/kb/224071

    http://support.microsoft.com/kb/314546

    Please use SQL Server 2008 R2 Upgrade Advisor as a preparation for upgrading to SQL Server 2008 R2.

    http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52

    Hope this helps.   
     
    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by SharpRan Wednesday, January 26, 2011 6:44 AM
    Tuesday, January 25, 2011 10:23 PM
  • Had the same problem with an upgrade.  Cause: the existing MS SQL 2005 was 32-bit, but the new 2008 version was 64-bit. The OS was 64-bit. Doh!

     

    Check the bit version by running SELECT @@Version .

    A 32-bit system returns something similar to: Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) ...

    A 64-bit system returns something similar to: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) ...

    Simply installed a 32-bit SQL 2008 version and the upgrade worked just fine.

     

    Gotta smile.

     

    <|:{D>~+<

     

    • Edited by marko-ek Tuesday, March 1, 2011 8:08 PM typo/clarification
    Tuesday, March 1, 2011 7:58 PM
  • In our case I was upgrading a SQL Server 2008 R2 evaluation 64b to Enterprise 64b. I was getting the same error after following the upgrade steps through the GUI (not from the prompt). After I stopped all services and run the setup.exe as an administrator I was able to upgrade with no problems and it took 1 min max.

    Panos.

    Wednesday, March 14, 2012 5:18 PM