There are no features to upgrade SQL 2005 Standard x64 to SQL 2008 R2 Ent x64

Question

I am trying to upgrade SQL 2005 Standard Edition x64 stand alone to SQL 2008 R2 Enterprise x64 stand alone.

When I try to do the in-place upgrade, I get an error There are no features selected to upgrade  at select features wizard page.

I confirmed with the following codes that I am running a correct installation option as x64.

SELECT SERVERPROPERTY('Edition')

Standard Edition (64-bit)

select @@VERSION

Microsoft SQL Server 2005 - 9.00.5000.00 (X64)   Dec 10 2010 10:38:40   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) 

Below is the Summary_[SERVERNAME]_20120213_093922_GlobalRules.txt

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Exit message:                  Passed
  Start time:                    2012-02-13 09:39:26
  End time:                      2012-02-13 09:40:01
  Requested action:              RunRules


Machine Properties:
  Machine name:                  [SERVERNAME]
  Machine processor count:       8
  OS version:                    Windows Server 2003
  OS service pack:               Service Pack 2
  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                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005      MSSQLSERVER          MSSQL.1                        SQL Server Replication                   1033                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005      MSSQLSERVER          MSSQL.1                        Full-Text Search                         1033                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005      MSSQLSERVER          MSSQL.1                        SharedTools                              1033                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005                                                          DTS                                      1033                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005                                                          Tools                                    1033                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005                                                          ToolsClient                              1033                 Standard Edition (64-bit) 9.4.5000        No        
  Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Standard Edition (64-bit) 9.4.5000        No        


Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         D:\SQL2008 R2\x64\setup\
  Installation edition:          ENTERPRISE


User Input Settings:
  ACTION:                        RunRules
  CONFIGURATIONFILE:             
  ENU:                           True
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  INSTANCENAME:                  <empty>
  PASSPHRASE:                    *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  RULES:                         GlobalRules
  UIMODE:                        Normal
  X86:                           False


  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120213_093922\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\20120213_093922\SystemConfigurationCheck_Report.htm

Any help would be appreciated much.

Thank you.

Answer 1

 

Hello,

When you run setup, you have to select "Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008". On requested action it should say “Upgrade”.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Thank you Alberto.

I am sorry I was not clear on OP.

I am selecting "Upgrade from SQL Server 2000, SQL 2005, or SQL Server 2008."

It says "Upgrade to SQL Server 2008 R2".

It just does not display anthing to upgrade when it gets to "Select Features" page on the wizard and, when I click NEXT, it displays error "There are no features selected to upgrade."

Thank you.

Answer 3

 

Hello,

Could you try to download the media again and extract its content to the hard drive and run setup from there. Maybe the media is corrupted.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Not that either.

I tried with extracted files from ISO on original post. And that worked fine for a 32 bit version on a dfferent server (in-place upgrade, new instance installation).

From you advice, I tried two different media ISO file types (DVD, USB)  that are downloaded in different times but I had the same result.

Thank you.

Answer 5

Anyone else can help on this?

Answer 6

Hi Yong Choi,

The problem may occur when a previous attempt to upgrade the instance of SQL Server 2005 failed and you try to upgrade again.

Please refer this KB article: http://support.microsoft.com/kb/955399.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 7

I was not able to resolve this issue Maggie.

I moved the folder as KB95399 indicated but the set up program crashed after installng installation "set up support" files.

I was going to retry after reboot but did not have a chance.