Asked by:
Upgrade from SQL 2008 to SQL 2008 R2 Failed
Question
-
I've done a search of this forum and my problem doesn't seem to have been addressed but I'm sorry if this a dup.
I have an instance of SQL 2005 and SQL 2008 running on Windows 2008 R1. I am trying to upgrade the 2008 instance to 2008 R2 but it is failing. I believe the relevant portion of the bootstrap\Logs\Details.txt is included at the bottom of this post. It looks to me like the upgrade is failing because I have a Developer version of SQL 2005. However, I'm not upgrading the 2005 instance but the 2008 instance (the existing 2008 is Enterprise and I'm wanting to upgrade it to 2008 R2 Enterprise which looks to be explicitly supported). I'm a developer with clients using both 2005 and 2008 so I need both versions running so I can't uninstall 2005. Any ideas?
Thanks!
Details.txt:
2011-01-06 17:55:18 Slp: Initializing rule : SQL Server 2008 R2 Feature Upgrade
2011-01-06 17:55:18 Slp: Rule applied features : ALL
2011-01-06 17:55:18 Slp: Rule is will be executed : True
2011-01-06 17:55:18 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SkuUpgradeRule
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_as_Cpu32'.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Found feature package 'sql_as_ctp6_Cpu32' with SkuValue=ENTERPRISE ProductVersion=10.0.1600.22
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' found sourceVersion 10.0 and edition ENTERPRISE for feature package 'sql_as_Cpu32'.
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix checking sku matrix for sourceVersion=10.0 sourceEdition=ENTERPRISE sourceArchitecture=X86 targetEdition=ENTERPRISE targetArchitecture=X86
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix source and target architecture match.
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix found match in sku matrix.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_as_Cpu32' permits upgrade.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_engine_core_inst_Cpu32'.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Found feature package 'sql_engine_core_inst_ctp6_Cpu32' with SkuValue=ENTERPRISE ProductVersion=10.0.1600.22
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' found sourceVersion 10.0 and edition ENTERPRISE for feature package 'sql_engine_core_inst_Cpu32'.
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix checking sku matrix for sourceVersion=10.0 sourceEdition=ENTERPRISE sourceArchitecture=X86 targetEdition=ENTERPRISE targetArchitecture=X86
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix source and target architecture match.
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix found match in sku matrix.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_engine_core_inst_Cpu32' permits upgrade.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_is_Cpu32'.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Found feature package 'IS2005_Cpu32' with SkuValue=DEVELOPER ProductVersion=9.3.4035.00
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' found sourceVersion 9.0 and edition DEVELOPER for feature package 'sql_is_Cpu32'.
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix checking sku matrix for sourceVersion=9.0 sourceEdition=DEVELOPER sourceArchitecture=X86 targetEdition=ENTERPRISE targetArchitecture=X86
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix source and target architecture match.
2011-01-06 17:55:18 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix did not find a match in sku matrix .
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_is_Cpu32' is blocking upgrade.
2011-01-06 17:55:18 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' detection result: IsValidFeatureUpgrade=False
2011-01-06 17:55:18 Slp: Evaluating rule : FeatureUpgradeMatrixCheck
2011-01-06 17:55:18 Slp: Rule running on machine: DEVSERVER
2011-01-06 17:55:18 Slp: Rule evaluation done : Failed
2011-01-06 17:55:18 Slp: Rule evaluation message: The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 R2 version and edition upgrade matrix in Books Online.
Friday, January 7, 2011 2:22 AM
All replies
-
Hello,
If I remember correctly, you can install SQL Server 2008 R2 as a named instance along with both the previous version of SQL Server (2005/08). Do you need an in-place upgrade or an additional instance with SQL Server 2008 R2 is fine for you?
It seems from the Details.txt that the setup was trying to upgrade the SQL Server 2005 Dev edition to SQL Server 2008 R2 Enterprise edition.
Could you please provide the Summary.txt from the "Setup BootStrap" folder?
SKG: Please Marked as Answered, if it resolves your issue.Friday, January 7, 2011 3:50 AM -
Thanks for replying so quickly.
I would prefer not to have 3 instances of sql running on my dev box (considering I typically run several instances of VS at a time plus normal apps it's decently taxed already for a middle of the road dev box).
Actually, I had selected my 2008 instance from the selection screen. That's why it's so strange that the 2005 instance would be blocking the upgrade. Maybe something to do with the shared components?
Here's the Summary.txt:
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-01-06 17:49:40
End time: 2011-01-06 17:56:18
Requested action: Upgrade
Machine Properties:
Machine name: DEVSERVER
Machine processor count: 4
OS version: Windows Server 2008
OS service pack: Service Pack 1
OS region: United States
OS language: English (United States)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 CSSQL2005 MSSQL.1 Database Engine Services 1033 Developer Edition 9.3.4035 No
Sql Server 2005 CSSQL2005 MSSQL.1 SQL Server Replication 1033 Developer Edition 9.3.4035 No
Sql Server 2005 CSSQL2005 MSSQL.1 Full-Text Search 1033 Developer Edition 9.3.4035 No
Sql Server 2005 CSSQL2005 MSSQL.1 SharedTools 1033 Developer Edition 9.3.4035 No
Sql Server 2005 CSSQL2005 MSSQL.2 Analysis Services 1033 Developer Edition 9.3.4035 No
Sql Server 2005 DTS 1033 Developer Edition 9.3.4035 No
Sql Server 2005 Tools 1033 Developer Edition 9.3.4035 No
Sql Server 2005 ToolsClient 1033 Developer Edition 9.3.4035 No
Sql Server 2005 ToolsClient\Connectivity 1033 Developer Edition 9.3.4035 No
Sql Server 2005 ToolsDocument 1033 Developer Edition 9.3.4035 No
Sql Server 2005 ToolsDocument\BOL 1033 Developer Edition 9.3.4035 No
Sql Server 2005 NS 1033 Developer Edition 9.3.4035 No
Sql Server 2008 CSSQL2008 MSSQL10.CSSQL2008 Database Engine Services 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 CSSQL2008 MSSQL10.CSSQL2008 SQL Server Replication 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 CSSQL2008 MSSQL10.CSSQL2008 Full-Text Search 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 CSSQL2008 MSAS10.CSSQL2008 Analysis Services 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 CSSQL2008 MSRS10.CSSQL2008 Reporting Services 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Basic 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Complete 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Connectivity 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 Client Tools SDK 1033 Enterprise Edition 10.0.1600.22 No
Sql Server 2008 Integration Services 1033 Enterprise Edition 10.0.1600.22 No
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
SPLevel: 0
Installation location: Z:\x86\setup\
Installation edition: ENTERPRISE
User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE:
CUSOURCE:
ENU: True
ERRORREPORTING: False
FAILOVERCLUSTERROLLOWNERSHIP: 2
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FTSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE
FTSVCPASSWORD: *****
FTUPGRADEOPTION: Rebuild
HELP: False
IACCEPTSQLSERVERLICENSETERMS: False
INDICATEPROGRESS: False
INSTANCEID: CSSQL2008
INSTANCENAME: CSSQL2008
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
PASSPHRASE: *****
PCUSOURCE:
PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAME: DEVSERVER\CSSQL2008
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
SQLDOMAINGROUP: <empty>
SQMREPORTING: False
UIMODE: Normal
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110106_174819\ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Client Connectivity
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Client Connectivity SDK
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Writer
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Browser
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Analysis Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Reporting Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Integration Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Compact Edition Tools
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Client Tools Connectivity
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Complete
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Basic
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Client Tools SDK
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Client Tools Backwards Compatibility
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Business Intelligence Development Studio
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Books Online
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110106_174819\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.SubmitAndWait(Request request)
at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceService.Waypoint(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)
Friday, January 7, 2011 6:17 AM -
Not sure, however, I will prefer to put SQL Server 2008 R2 as a named instance, then migrate all the databases, logins, jobs etc to the 2008 R2 instance. Once everything is tested working fine, then I may uninstall the Server 2008. I always prefer a side-by-side migration; but in your case I think it may be one of the suitable options.
SKG: Please Marked as Answered, if it resolves your issue.Friday, January 7, 2011 7:55 AM -
Hi ch3lk,
Based on my research, this issue might be caused by that the shared components are in different edition.
For troubleshooting, please try uninstalling all the shared components of SQL Server 2005 and try again.
If anything is unclear, please let me know.
Regards,
Tom LiTuesday, January 11, 2011 6:37 AM -
can you describe whether you are trying to run setup.exe with command Prompt and not entered PID?
ManishTuesday, November 29, 2011 7:25 AM
