Unable to install SQL Server(setup.exe). Exit Code(Decimal: 2061893606Error description. Wait on the Database Engine recovery handle failed

Obehi 41 Reputation points
2022-01-30T05:25:54.72+00:00

169510-image.png

SQL Server | Other
{count} votes

13 answers

Sort by: Most helpful
  1. Obehi 41 Reputation points
    2022-02-03T23:21:58.937+00:00

    Hello @Erland Sommarskog

    I have done everything as stated in the document (https://learn.microsoft.com/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size) and its still not working.

    I have checked the Firewall and opened the ports 1433, 1434 etc.

    I have checked the registry key...

    Still got the below error:

    Detailed results:
    Feature: Database Engine Services
    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, uninstall this feature, and then run the setup process again.
    Component name: SQL Server Database Engine Services Instance Features
    Component error code: 0x851A001A
    Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
    Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

    0 comments No comments

  2. Obehi 41 Reputation points
    2022-02-04T22:23:40.48+00:00

    Hello @Erland Sommarskog and @YufeiShao-msft

    I have successfully installed SQL Server 2019.

    Thank you for your help.

    Regards,
    Obehi


  3. Francia Diaz 1 Reputation point
    2022-08-11T19:37:35.237+00:00

    Has anyone else found a solution besides editing the registry keys? :-(


  4. Han Hoan 1 Reputation point
    2022-09-28T10:50:27.64+00:00

    I have the same issue as him, and i dont know how to fix even tho i tried some links above
    Can sb help me
    This is the log:Overall summary:
    Final result: Failed: see details below
    Exit code (Decimal): -2061893606
    Start time: 2022-09-28 17:44:10
    End time: 2022-09-28 17:47:32
    Requested action: Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
    Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

    Machine Properties:
    Machine name: TTRUC
    Machine processor count: 8
    OS version: Microsoft Windows 11 Home Single Language (10.0.22621)
    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

    Package properties:
    Description: Microsoft SQL Server 2019
    ProductName: SQL Server 2019
    Type: RTM
    Version: 15
    SPLevel: 0
    Installation location: C:\SQL2019\Developer_ENU\x64\setup\
    Installation edition: Developer

    Product Update Status:
    User selected not to include product updates.

    User Input Settings:
    ACTION: Install
    ADDCURRENTUSERASSQLADMIN: false
    AGTSVCACCOUNT: NT Service\SQLSERVERAGENT
    AGTSVCPASSWORD: *****
    AGTSVCSTARTUPTYPE: Manual
    ASBACKUPDIR: Backup
    ASCOLLATION: Latin1_General_CI_AS
    ASCONFIGDIR: Config
    ASDATADIR: Data
    ASLOGDIR: Log
    ASPROVIDERMSOLAP: 1
    ASSERVERMODE: TABULAR
    ASSVCACCOUNT: <empty>
    ASSVCPASSWORD: <empty>
    ASSVCSTARTUPTYPE: Automatic
    ASSYSADMINACCOUNTS: <empty>
    ASTELSVCACCT: <empty>
    ASTELSVCPASSWORD: <empty>
    ASTELSVCSTARTUPTYPE: 0
    ASTEMPDIR: Temp
    BROWSERSVCSTARTUPTYPE: Disabled
    CLTCTLRNAME: <empty>
    CLTRESULTDIR: <empty>
    CLTSTARTUPTYPE: 0
    CLTSVCACCOUNT: <empty>
    CLTSVCPASSWORD: <empty>
    CLTWORKINGDIR: <empty>
    COMMFABRICENCRYPTION: 0
    COMMFABRICNETWORKLEVEL: 0
    COMMFABRICPORT: 0
    CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220928_174352\ConfigurationFile.ini
    CTLRSTARTUPTYPE: 0
    CTLRSVCACCOUNT: <empty>
    CTLRSVCPASSWORD: <empty>
    CTLRUSERS: <empty>
    ENABLERANU: false
    ENU: true
    EXTSVCACCOUNT: <empty>
    EXTSVCPASSWORD: <empty>
    FEATURES: SQLENGINE
    FILESTREAMLEVEL: 0
    FILESTREAMSHARENAME: <empty>
    FTSVCACCOUNT: <empty>
    FTSVCPASSWORD: <empty>
    HELP: false
    IACCEPTPYTHONLICENSETERMS: false
    IACCEPTROPENLICENSETERMS: false
    IACCEPTSQLSERVERLICENSETERMS: true
    IACKNOWLEDGEENTCALLIMITS: false
    INDICATEPROGRESS: true
    INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
    INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
    INSTALLSQLDATADIR: <empty>
    INSTANCEDIR: C:\Program Files\Microsoft SQL Server
    INSTANCEID: MSSQLSERVER
    INSTANCENAME: MSSQLSERVER
    ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service
    ISMASTERSVCPASSWORD: <empty>
    ISMASTERSVCPORT: 8391
    ISMASTERSVCSSLCERTCN: <empty>
    ISMASTERSVCSTARTUPTYPE: Automatic
    ISMASTERSVCTHUMBPRINT: <empty>
    ISSVCACCOUNT: NT AUTHORITY\Network Service
    ISSVCPASSWORD: <empty>
    ISSVCSTARTUPTYPE: Automatic
    ISTELSVCACCT: <empty>
    ISTELSVCPASSWORD: <empty>
    ISTELSVCSTARTUPTYPE: 0
    ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service
    ISWORKERSVCCERT: <empty>
    ISWORKERSVCMASTER: <empty>
    ISWORKERSVCPASSWORD: <empty>
    ISWORKERSVCSTARTUPTYPE: Automatic
    MATRIXCMBRICKCOMMPORT: 0
    MATRIXCMSERVERNAME: <empty>
    MATRIXNAME: <empty>
    MRCACHEDIRECTORY:
    NPENABLED: 0
    PBDMSSVCACCOUNT: <empty>
    PBDMSSVCPASSWORD: <empty>
    PBDMSSVCSTARTUPTYPE: 0
    PBENGSVCACCOUNT: <empty>
    PBENGSVCPASSWORD: <empty>
    PBENGSVCSTARTUPTYPE: 0
    PBPORTRANGE: <empty>
    PBSCALEOUT: false
    PID: *****
    QUIET: true
    QUIETSIMPLE: false
    ROLE:
    RSINSTALLMODE: DefaultNativeMode
    RSSVCACCOUNT: <empty>
    RSSVCPASSWORD: <empty>
    RSSVCSTARTUPTYPE: Automatic
    SAPWD: <empty>
    SECURITYMODE: <empty>
    SQLBACKUPDIR: <empty>
    SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
    SQLJAVADIR: <empty>
    SQLMAXDOP: 8
    SQLMAXMEMORY: 2147483647
    SQLMINMEMORY: 0
    SQLSVCACCOUNT: NT Service\MSSQLSERVER
    SQLSVCINSTANTFILEINIT: true
    SQLSVCPASSWORD: <empty>
    SQLSVCSTARTUPTYPE: Automatic
    SQLSYSADMINACCOUNTS: TTRUC\hhoan
    SQLTELSVCACCT: NT Service\SQLTELEMETRY
    SQLTELSVCPASSWORD: <empty>
    SQLTELSVCSTARTUPTYPE: Automatic
    SQLTEMPDBDIR: <empty>
    SQLTEMPDBFILECOUNT: 8
    SQLTEMPDBFILEGROWTH: 64
    SQLTEMPDBFILESIZE: 8
    SQLTEMPDBLOGDIR: <empty>
    SQLTEMPDBLOGFILEGROWTH: 64
    SQLTEMPDBLOGFILESIZE: 8
    SQLUSERDBDIR: <empty>
    SQLUSERDBLOGDIR: <empty>
    SUPPRESSPAIDEDITIONNOTICE: false
    SUPPRESSPRIVACYSTATEMENTNOTICE: false
    TCPENABLED: 0
    UIMODE: Normal
    UpdateEnabled: false
    UpdateSource: MU
    USEMICROSOFTUPDATE: false
    USESQLRECOMMENDEDMEMORYLIMITS: false
    X86: false

    Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220928_174352\ConfigurationFile.ini

    Detailed results:
    Feature: Database Engine Services
    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, uninstall this feature, and then run the setup process again.
    Component name: SQL Server Database Engine Services Instance Features
    Component error code: 0x851A001A
    Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
    Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

    Feature: SQL Browser
    Status: Passed

    Feature: SQL Writer
    Status: Passed

    Rules with failures or warnings:

    Global rules:
    Warning IsFirewallEnabled The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at https://go.microsoft.com/fwlink/?linkid=2094702 for information about ports to open for each feature.

    Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220928_174352\SystemConfigurationCheck_Report.htm


  5. Han Hoan 1 Reputation point
    2022-09-28T10:56:54.347+00:00

    Hi you guys, i have the same issue and i tried all links before but no one works
    This is my log, sorry for my bad english:

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.