locked
Upgrade from SQL 2008 to SQL 2008 R2 Failed RRS feed

  • 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 Li
    Tuesday, January 11, 2011 6:37 AM
  • can you describe whether you are trying to run setup.exe with command Prompt and not entered PID?
    Manish
    Tuesday, November 29, 2011 7:25 AM