Monday, February 13, 2012 6:14 PM
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.
Standard Edition (64-bit)
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
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 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
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Installation location: D:\SQL2008 R2\x64\setup\
Installation edition: ENTERPRISE
User Input Settings:
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120213_093922\ConfigurationFile.ini
Rules with failures:
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.
Monday, February 13, 2012 7:25 PMModerator
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.
Monday, February 13, 2012 7:32 PM
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."
Monday, February 13, 2012 8:48 PMModerator
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.
Monday, February 13, 2012 10:00 PM
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.
Tuesday, February 14, 2012 9:18 PM
Anyone else can help on this?
Friday, February 24, 2012 7:52 AMModerator
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.
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.
Monday, February 27, 2012 4:39 PM
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.