none
SQL Server Upgrade Error(From 2005 to 2008)

    Question

  • Hi, I am trying to in-place upgrade sql server from 2005 to 2008. Everything went smoothly but the database engine, SQL Server Replication, Full-Text Search, AS, and RS failed to upgrade.

    The log as following. The MSI Error code is 0xB8A6B4FA.

    Anyone has any thoughts about it? Thank you very much!!!

    Overall summary:
      Final result:                  SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server using the following command line, and then rerun SQL Server Setup. Uninstall command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine,Replication,FullText,AS,RS
      Exit code (Decimal):           -2068643839
      Exit facility code:            1203
      Exit error code:               1
      Exit message:                  SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server using the following command line, and then rerun SQL Server Setup. Uninstall command line: setup /q /action=uninstall /instanceid=MSSQLSERVER /features=SQLEngine,Replication,FullText,AS,RS
      Start time:                    2017-05-01 15:21:41
      End time:                      2017-05-01 15:24:33
      Requested action:              Upgrade
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_rs_Cpu32_1.log
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22

    Machine Properties:
      Machine name:                  MGM-SQLREP8
      Machine processor count:       8
      OS version:                    Windows Server 2003
      OS service pack:               Service Pack 2
      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      MSSQLSERVER          MSSQL.1                        Database Engine Services                 1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        SQL Server Replication                   1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        Full-Text Search                         1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.1                        SharedTools                              1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.2                        Analysis Services                        1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005      MSSQLSERVER          MSSQL.3                        Reporting Services                       1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          Tools                                    1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          ToolsClient                              1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          ToolsDocument                            1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          ToolsDocument\BOL                        1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          ToolsDocument\Samples                    1033                 Enterprise Edition   9.4.5069        No        
      Sql Server 2005                                                          NS                                       1033                 Enterprise Edition   9.4.5069        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        

    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         Z:\x86\setup\
      Installation edition:          ENTERPRISE

    User Input Settings:
      ACTION:                        Upgrade
      AGTDOMAINGROUP:                <empty>
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\ConfigurationFile.ini
      ERRORREPORTING:                False
      FAILOVERCLUSTERROLLOWNERSHIP:  2
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      FTUPGRADEOPTION:               Rebuild
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      MEDIASOURCE:                   Z:\
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      RSCATALOGSERVERINSTANCENAME:   MGM-SQLREP8
      RSUPGRADEDATABASEACCOUNT:      
      RSUPGRADEPASSWORD:             *****
      SQLDOMAINGROUP:                <empty>
      SQMREPORTING:                  False
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\ConfigurationFile.ini

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_engine_core_inst_Cpu32_1.log
      MSI error description:         
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_rs_Cpu32_1.log
      MSI error description:         
      Configuration status:          Passed

      Feature:                       SQL Server Replication
      Status:                        Failed: see logs for details
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_engine_core_inst_Cpu32_1.log
      MSI error description:         
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_rs_Cpu32_1.log
      MSI error description:         
      Configuration status:          Passed

      Feature:                       Full-Text Search
      Status:                        Failed: see logs for details
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_engine_core_inst_Cpu32_1.log
      MSI error description:         
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_rs_Cpu32_1.log
      MSI error description:         
      Configuration status:          Passed

      Feature:                       Analysis Services
      Status:                        Failed: see logs for details
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_as_Cpu32_1.log
      MSI error description:         
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_rs_Cpu32_1.log
      MSI error description:         
      Configuration status:          Passed

      Feature:                       Reporting Services
      Status:                        Failed: see logs for details
      MSI status:                    Failed: see details below
      MSI error code:                0xB8A6B4FA
      MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\sql_rs_Cpu32_1.log
      MSI error description:         
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\SystemConfigurationCheck_Report.htm

    Monday, May 1, 2017 8:28 PM

All replies

  • Have you looked at this?

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d2821168-e25c-4da1-ae27-3b1b7d3fb5b6/sql-server-2008-express-failed-to-install?forum=sqlexpress

    I would be remiss not to point out that SQL 2008 is out of support now and is not a wise choice to upgrade from SQL 2005 to.

    Monday, May 1, 2017 8:44 PM
  • Thank you!

    yes i know 2008 not supprted. But we need SQL 2008

    Monday, May 1, 2017 8:53 PM
  • Hi yxzhou624,

    Was the issue resolved? If not , could you please locate and upload the corresponding SQL Server installation log and upload it to file share services(Dropbox, OneDrive etc.) then share the link here so we can take a further look into the issue?

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, May 2, 2017 5:46 AM
    Moderator
  • Thank you for your reply.

    I tried different ways and still cannot resolve it. Really frustrated.

    The share link below is the detail logs:

    https://1drv.ms/f/s!Aor3CcZ-pggjixCvHZsGMLPhFsyP

    Thank you for your time!

    Tuesday, May 2, 2017 4:04 PM
  • Hi yxzhou624,

    Please upload all files under C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170502_104239\ as there is not much information in detail.txt. 

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, May 4, 2017 8:17 AM
    Moderator
  • Done!! Please Check.

    Thank you!!!

    https://1drv.ms/f/s!Aor3CcZ-pggjiybpTUMCslvlW9zz

    Thursday, May 4, 2017 2:15 PM