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: 2
Please review the summary.txt log for further details
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 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
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Installation edition: EVAL
User Input Settings:
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110125_114242\ConfigurationFile.ini
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110125_114242\ConfigurationFile.ini
Rules with failures:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110125_114242\SystemConfigurationCheck_Report.htm
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
No feature were uninstalled during the setup execution. The requested features may not be installed. Please review the summary.txt logs for further details.
Tuesday, January 25, 2011 10:55 AMModerator
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
Tuesday, January 25, 2011 10:23 PMModerator
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.
Please use SQL Server 2008 R2 Upgrade Advisor as a preparation for upgrading to SQL Server 2008 R2.
Hope this helps.
- 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.
- 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.