See the SQL Server error log for details.
As the message says, review the SQL Server ErrorLog and also the installation log for more details
View the SQL Server error log in SQL Server Management Studio (SSMS)
Viewing the SQL Server Error Log
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
Im trying to upgrade my SQL from 2016 to 2019 when I encountered the error. I also tried the Repair feature to resolve it.
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2061527938
Start time: 2021-03-31 04:41:49
End time: 2021-03-31 04:47:39
Requested action: Repair
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for Replication: Use the following information to resolve the error, and then try the setup process again.
Machine Properties:
Machine name: ODB03
Machine processor count: 4
OS version: Microsoft Windows Server 2016 Datacenter (10.0.14393)
OS service pack:
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 Configured
SQL Server 2016 SSMS 1033 Standard Edition 13.0.16106.4 No Yes
SQL Server 2016 Client Tools Connectivity 1033 Standard Edition 13.0.14500.10 No Yes
SQL Server 2016 Client Tools Backwards Compatibility 1033 Standard Edition 13.0.14500.10 No Yes
SQL Server 2016 Client Tools SDK 1033 Standard Edition 13.0.14500.10 No Yes
SQL Server 2016 Data Quality Client 1033 Standard Edition 13.2.5026.0 No Yes
SQL Server 2016 Integration Services 1033 Standard Edition 13.2.5882.1 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER SQL Server Replication 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Data Quality Services 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSAS15.MSSQLSERVER Analysis Services 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 Data Quality Client 1033 Standard Edition 15.0.2000.5 No Yes
SQL Server 2019 Integration Services 1033 Standard Edition 15.0.2000.5 No Yes
Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation location: H:\x64\setup\
Installation edition: Standard
User Input Settings:
ACTION: Repair
AGTDOMAINGROUP: <empty>
AGTSVCACCOUNT: .\SQLServices
AGTSVCPASSWORD: <empty>
AGTSVCSTARTUPTYPE: Automatic
ASCONFIGDIR: Config
ASSVCACCOUNT: NT Service\MSSQLServerOLAPService
ASSVCPASSWORD: <empty>
ASTELSVCACCT: NT Service\SSASTELEMETRY
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: Automatic
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210331_044148\ConfigurationFile.ini
CTLRSTARTUPTYPE: Manual
CTLRSVCACCOUNT: NT Service\SQL Server Distributed Replay Controller
CTLRSVCPASSWORD: <empty>
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FAILOVERCLUSTERGROUP: <empty>
FAILOVERCLUSTERNETWORKNAME: <empty>
FTSVCACCOUNT: NT Service\MSSQLFDLauncher
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: false
INSTANCENAME: MSSQLSERVER
ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service
ISMASTERSVCPASSWORD: <empty>
ISMASTERSVCPORT: 8391
ISMASTERSVCSSLCERTCN: <empty>
ISMASTERSVCSTARTUPTYPE: Automatic
ISMASTERSVCTHUMBPRINT: <empty>
ISSVCACCOUNT: NT Service\MsDtsServer150
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: NT Service\SSISTELEMETRY150
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: Automatic
ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service
ISWORKERSVCCERT: <empty>
ISWORKERSVCMASTER: <empty>
ISWORKERSVCPASSWORD: <empty>
ISWORKERSVCSTARTUPTYPE: Automatic
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCPASSWORD: <empty>
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210331_044148\ConfigurationFile.ini
Detailed results:
Feature: Data Quality Services
Status: Passed
Feature: Full-Text and Semantic Extractions for Search
Status: Passed
Feature: Database Engine Services
Status: Passed
Feature: SQL Server Replication
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x851F947E
Error description: There was an error executing the Replication upgrade scripts. See the SQL Server error log for details.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4034.2&EvtType=0x21F8068D%400xC652C608%401311%4038014&EvtType=0x21F8068D%400xC652C608%401311%4038014
Feature: Analysis Services
Status: Passed
Feature: SQL Browser
Status: Passed
Feature: SQL Writer
Status: Passed
Feature: Distributed Replay Controller
Status: Passed
Feature: Integration Services
Status: Passed
Feature: SQL Client Connectivity SDK
Status: Passed
Feature: SQL Client Connectivity
Status: Passed
Feature: Data Quality Client
Status: Passed
Feature: Setup Support Files
Status: Passed
Rules with failures or warnings:
Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210331_044148\SystemConfigurationCheck_Report.htm
The following warnings were encountered while configuring settings on your SQL Server. These resources / settings were missing or invalid so default values were used in recreating the missing resources. Please review to make sure they don’t require further customization for your applications:
Service SID support has been enabled on the service.
Service SID support has been enabled on the service.
See the SQL Server error log for details.
As the message says, review the SQL Server ErrorLog and also the installation log for more details
View the SQL Server error log in SQL Server Management Studio (SSMS)
Viewing the SQL Server Error Log