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: BROWSERSVCSTARTUPTYPE: Disabled CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20170501_152027\ConfigurationFile.ini ERRORREPORTING: False FAILOVERCLUSTERROLLOWNERSHIP: 2 FTSVCACCOUNT: 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: 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