There are no features selected for upgrade
-
Tuesday, January 25, 2011 9:53 AM
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: 2Please 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: UninstallMachine 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: NoProduct 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 NoPackage properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation edition: EVALUser 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: FalseConfiguration 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 indentedException 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
All Replies
-
Tuesday, January 25, 2011 10:55 AMModerator
Hello,
Try to uninstall SQL Server 2005 manually using the following article:
http://support.microsoft.com/kb/909967Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Tuesday, January 25, 2011 3:05 PMuninstalling 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 10:23 PMModerator
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/314546Please 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, March 01, 2011 7:58 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.
- Edited by marko-ek Tuesday, March 01, 2011 8:08 PM typo/clarification
-
Wednesday, March 14, 2012 5:18 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.

