none
Rule "SQL Server 2012 feature Upgrade" Failed

    Frage

  • 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 : RulesEngineNotificationChannel

    Prior 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:              RunRules

    Machine 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:                  No

    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    No       

    Package properties:
      Description:                   Microsoft SQL Server 2012
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      Installation location:         \\dovekie\drop\TFS2013\SQLServer2012SP1\x64\setup\
      Installation edition:          Standard

      Slipstream:                    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:                           false

      Configuration 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
    Sonntag, 29. Dezember 2013 12:59

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    No       

    Package properties:
      Description:                   Microsoft SQL Server 2012
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      Installation location:         \\dovekie\drop\TFS2013\SQLServer2012SP1\x64\setup\
      Installation edition:          Standard

      Slipstream:                    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

    Sonntag, 29. Dezember 2013 13:12

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    No       

    Package properties:
      Description:                   Microsoft SQL Server 2012
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      Installation location:         \\dovekie\drop\TFS2013\SQLServer2012SP1\x64\setup\
      Installation edition:          Standard

      Slipstream:                    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

    Sonntag, 29. Dezember 2013 13:12
  • 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

    Sonntag, 29. Dezember 2013 15:11