Benutzer mit den meisten Antworten
Rule "SQL Server 2012 feature Upgrade" Failed

-
I am doing an in-place upgrade of SQL Server 2008 R2 SP2 > SQL Server 2012 SP1, both 64-bit, installed on Windows Server 2008 R2.
I ran the SQL Server Upgrade Advisor tool prior to upgrade which reported no issues.
The error I am getting is:
In the detailed.txt log I can see the following:
(11) 2013-12-29 12:28:10 Slp: Initializing rule : SQL Server 2012 Feature Upgrade
(11) 2013-12-29 12:28:10 Slp: Rule is will be executed : True
(11) 2013-12-29 12:28:10 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SkuUpgradeRule
(11) 2013-12-29 12:28:10 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_as_Cpu64'.
(11) 2013-12-29 12:28:10 Slp: -- SkuUpgradeRule : Found feature package 'sql_as_ctp6_Cpu64' with SkuValue=ENTERPRISE (Enterprise) ProductVersion=10.52.4000.0
(11) 2013-12-29 12:28:10 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' found sourceVersion 10.0 and edition ENTERPRISE for feature package 'sql_as_Cpu64'.
(11) 2013-12-29 12:28:10 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix checking sku matrix for sourceVersion=10.0 sourceEdition=ENTERPRISE (Enterprise) sourceArchitecture=X64 targetEdition=STANDARD (Standard) targetArchitecture=X64
(11) 2013-12-29 12:28:10 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix source and target architecture match.
(11) 2013-12-29 12:28:10 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix did not find a match in sku matrix .
(11) 2013-12-29 12:28:10 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_as_Cpu64' is blocking upgrade.
(11) 2013-12-29 12:28:10 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' detection result: IsValidFeatureUpgrade=False
(11) 2013-12-29 12:28:10 Slp: Evaluating rule : FeatureUpgradeMatrixCheck
(11) 2013-12-29 12:28:10 Slp: Rule running on machine: TAUPE-SERVER
(11) 2013-12-29 12:28:10 Slp: Rule evaluation done : Failed
(11) 2013-12-29 12:28:10 Slp: Rule evaluation message: The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2012 version and edition upgrade in Books Online.
(11) 2013-12-29 12:28:10 Slp: Send result to channel : RulesEngineNotificationChannelPrior to upgrade:
From Summary.txt file:
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2013-12-29 12:04:28
End time: 2013-12-29 12:08:02
Requested action: RunRulesMachine Properties:
Machine name: TAUPE-SERVER
Machine processor count: 1
OS version: Windows Server 2008 R2
OS service pack: Service Pack 1
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 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSAS10_50.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services - Native 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.52.4000.0 NoPackage properties:
Description: Microsoft SQL Server 2012
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: \\dovekie\drop\TFS2013\SQLServer2012SP1\x64\setup\
Installation edition: StandardSlipstream: True
User Input Settings:
ACTION: RunRules
CONFIGURATIONFILE:
ENU: true
FEATURES:
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
INSTANCENAME: <empty>
PID: *****
QUIET: false
QUIETSIMPLE: false
RULES: GlobalRules
UIMODE: Normal
X86: falseConfiguration file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20131229_120425\ConfigurationFile.ini
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20131229_120425\SystemConfigurationCheck_Report.htm
As far as I'm aware, the upgrade path I am following is a supported one, any suggestions will be much appreciated!
Thank you.
- Bearbeitet dcole82 Sonntag, 29. Dezember 2013 13:11
Frage
Antworten
-
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSAS10_50.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services - Native 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.52.4000.0 NoPackage properties:
Description: Microsoft SQL Server 2012
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: \\dovekie\drop\TFS2013\SQLServer2012SP1\x64\setup\
Installation edition: StandardSlipstream: True
User Input
Hello ,
You are trying to upgrade to SQL 2012 standard edition which is not supported .you can only upgrade from SQL server 2008 R2 Sp2 Enterprise edition to SQL 2012 Enterprise or business intellgience. see below link for supported upgrade paths
http://technet.microsoft.com/en-us/library/ms143393.aspx
If you want to move ahead you should try Side by side approach.Create new SQL server 2012 box and restore backup.Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Als Antwort vorgeschlagen Alisa TangMicrosoft contingent staff Montag, 30. Dezember 2013 07:40
- Als Antwort markiert dcole82 Mittwoch, 1. Januar 2014 21:59
Alle Antworten
-
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSAS10_50.MSSQLSERVER Analysis Services 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 MSSQLSERVER MSRS10_50.MSSQLSERVER Reporting Services - Native 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.52.4000.0 No
SQL Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.52.4000.0 NoPackage properties:
Description: Microsoft SQL Server 2012
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: \\dovekie\drop\TFS2013\SQLServer2012SP1\x64\setup\
Installation edition: StandardSlipstream: True
User Input
Hello ,
You are trying to upgrade to SQL 2012 standard edition which is not supported .you can only upgrade from SQL server 2008 R2 Sp2 Enterprise edition to SQL 2012 Enterprise or business intellgience. see below link for supported upgrade paths
http://technet.microsoft.com/en-us/library/ms143393.aspx
If you want to move ahead you should try Side by side approach.Create new SQL server 2012 box and restore backup.Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Als Antwort vorgeschlagen Alisa TangMicrosoft contingent staff Montag, 30. Dezember 2013 07:40
- Als Antwort markiert dcole82 Mittwoch, 1. Januar 2014 21:59
-
SQL Server does not support upgrading from Enterprise Edition to Developer Edition. Go through the below link;
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.110).aspx