No Features Selected for Upgrade.

Applies to: SQL Server 2005 Express Edition, SQL Server 2008 R2 Express Edition, Windows 7 64-bit.
 

Problem Description.
 

A computer consultant approached me in relation to a failed installation of SQL Server in his laptop. He told me we had tried many times to upgrade the current SQL Server 2005 Express Edition instance installed in his laptop to SQL Server 2008 R2 Express Edition, but the upgrade process always ended with the same error. I asked him to run SQL Server 2008 R2 setup again and show me the error.

When he ran setup, he chose "Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008" on SQL Server Installation Center and then follow instructions.







However, on the "Select Features" page of setup the following error message appeared.

Upgrade to SQL Server 2008 R2
There are validation errors on this page. Click OK to close this dialog box. Review errors at the
bottom of the setup page, then provide valid parameters or click Help for more information.



When he clicked OK on the above dialog, a new error appeared at the bottom of the "Select Features" page.
 

There are no features selected for upgrade.

I proceeded to view SQL Server setup summary.txt log and found the following:


Overall summary:
Final result: User cancelled
Exit code (Decimal): -2068380094
Exit facility code: 1207
Exit error code: 1602
Exit message: User has cancelled.
Start time: 2011-08-26 17:47:14
End time: 2011-08-26 18:16:57
Requested action: Upgrade

Machine Properties:
Machine name: DENVER
Machine processor count: 2
OS version: Windows 7
OS service pack: Service Pack 1
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 NR2007 MSSQL.2 Database Engine Services 1033 Express Edition 9.4.5000 No
Sql Server 2005 NR2007 MSSQL.2 SharedTools 1033 Express Edition 9.4.5000 No
Sql Server 2005 SQLEXPRESS MSSQL.3 Database Engine Services 1033 Express Edition 9.4.5000 No
Sql Server 2005 SQLEXPRESS MSSQL.3 SharedTools 1033 Express Edition 9.4.5000 No
Sql Server 2005 Tools 1033 Express Edition 9.4.5000 No
Sql Server 2005 ToolsClient 1033 Express Edition 9.4.5000 No
Sql Server 2005 ToolsClient\Connectivity 1033 Express Edition 9.4.5000 No
Sql Server 2008 R2 Management Tools - Basic 1033 Express Edition 10.50.1600.1 No

Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: y:\6d9eb6bef166b4e8a3f4a0462acf\x64\setup\
Installation edition: EXPRESS

User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE:
CUSOURCE:
ENU: True
ERRORREPORTING: False
FAILOVERCLUSTERROLLOWNERSHIP: 2
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
FTUPGRADEOPTION: Import
HELP: False
IACCEPTSQLSERVERLICENSETERMS: False
INDICATEPROGRESS: False
INSTANCEID: <empty>
INSTANCENAME: <empty>
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
PASSPHRASE: *****
PCUSOURCE:
PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAME: Unknown
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
SQLDOMAINGROUP: <empty>
SQMREPORTING: True
UIMODE: AutoAdvance
X86: False

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

Detailed results:

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110826_174309\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.Chainer.Infrastructure.CancelException
Message:
User has cancelled.
Stack:
at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)



Cause.


The computer consultant was using SQL Server 2008 R2 Express 64-bit (SQLEXPR_x64_ENU) setup program to upgrade a 32-bit instance of SQL Server 2005 Express Edition. Setup cannot upgrade from 32-bit platform to 64-bit platform: cross-platform upgrade is not supported.


Solution.

I ran SQL Server 2008 R2 Express 32-bit (SQLEXPR_x86_ENU.exe) setup program and setup was able to detect the existing 32-bit instance of SQL Server 2005 Express and upgraded it successfully.



 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.