Error installing SQL Server: Exit code(Decimal):-2061893606 Error description: Wait on the database Engine recoveryhandle failed SQL installation failed

Question

Hello, I have been having issues installing the sql server
The error log I got is pasted below

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2061893606
  Start time:                    2023-01-31 10:19:58
  End time:                      2023-01-31 10:21:44
  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:                  AGENT-DANIEL
  Machine processor count:       8
  OS version:                    Microsoft Windows 11 Home (10.0.22000)
  OS service pack:               
  OS region:                     United Kingdom
  OS language:                   English (United Kingdom)
  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 2022      MSSQLSERVER          MSSQL16.MSSQLSERVER            Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER01        MSSQL16.MSSQLSERVER01          Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER02        MSSQL16.MSSQLSERVER02          Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER03        MSSQL16.MSSQLSERVER03          Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER04        MSSQL16.MSSQLSERVER04          Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      SQLEXPRESS           MSSQL16.SQLEXPRESS             Database Engine Services                 1033                 Express Edition      16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER05        MSSQL16.MSSQLSERVER05          Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER06        MSSQL16.MSSQLSERVER06          Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       

Package properties:
  Description:                   Microsoft SQL Server 2022 
  ProductName:                   SQL Server 2022
  Type:                          RTM
  Version:                       16
  SPLevel:                       0
  Installation location:         C:\SQL2022\Developer_ENU\x64\setup\
  Installation edition:          Developer

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

Notice: Please read Microsoft SQL Server Software License Terms at aka.ms/useterms.

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      false
  AGTSVCACCOUNT:                 NT Service\SQLAgent$MSSQLSERVER07
  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
  AZUREARCPROXYSERVER:           <empty>
  AZUREBILLEDEDITION:            
  AZUREREGION:                   <empty>
  AZURERESOURCEGROUP:            <empty>
  AZURESERVICEPRINCIPAL:         <empty>
  AZURESERVICEPRINCIPALSECRET:   <empty>
  AZURESUBSCRIPTIONID:           <empty>
  AZURETENANTID:                 <empty>
  BROWSERSVCSTARTUPTYPE:         Disabled
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230131_101957\ConfigurationFile.ini
  ENABLERANU:                    false
  ENU:                           true
  EXTSVCACCOUNT:                 <empty>
  EXTSVCPASSWORD:                <empty>
  FEATURES:                      SQLENGINE
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 <empty>
  HELP:                          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:                    MSSQLSERVER07
  INSTANCENAME:                  MSSQLSERVER07
  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
  NPENABLED:                     0
  PBDMSSVCACCOUNT:               <empty>
  PBDMSSVCPASSWORD:              <empty>
  PBDMSSVCSTARTUPTYPE:           0
  PBENGSVCACCOUNT:               <empty>
  PBENGSVCPASSWORD:              <empty>
  PBENGSVCSTARTUPTYPE:           0
  PBPORTRANGE:                   <empty>
  PID:                           *****
  PRODUCTCOVEREDBYSA:            false
  QUIET:                         true
  QUIETSIMPLE:                   false
  ROLE:                          
  SAPWD:                         <empty>
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  Latin1_General_CI_AS
  SQLMAXDOP:                     8
  SQLMAXMEMORY:                  2147483647
  SQLMINMEMORY:                  0
  SQLSVCACCOUNT:                 NT Service\MSSQL$MSSQLSERVER07
  SQLSVCINSTANTFILEINIT:         true
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           AGENT-DANIEL\infon
  SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$MSSQLSERVER07
  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

  Configuration file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230131_101957\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=16.0.1000.6&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

Rules with failures or warnings:

Rules report file:               C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230131_101957\SystemConfigurationCheck_Report.htm

Answer 1

Hi @Olusoji Daniel

Windows 11 uses different block sizes for disc alignment (32k) which aren't supported by SQL Server.

Here is a workaround: Troubleshoot errors related to system disk sector size greater than 4 KB.

If still not work, please post the error logs.

The location by default is: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log

There is a summary.txt file and many subfolders created every time the Installation wizard is started. In those subfolders, we can find a Detail.txt file.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Olusoji Daniel ,

Welcome to Microsoft Q&A forum.

As I understand from the question, you are getting Wait on the Database Engine recovery handle failed when trying to install SQL Server.

If you are working it on Windows 11, please follow the steps below if this helps:

1. Uninstall all the SQL instances one by one ----Goto--control panel - uninstall a program - Microsoft SQL server (64 bit) - select remove option, select the particular instance, and uninstall.
2. Repeat the same process till you uninstall all instances. Goto C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER (MSSQLSERVER indicates instances). Should not have any instances like this ex: MSSQL15.MSSQLSERVER.
3. Restart the computer.
4. Downloaded SQL server 2019 developer version and run as administrator choose basic installation process.
   https://www.microsoft.com/en-us/sql-server/sql-server-downloads(SQL2019-SSEI-Dev)
5. Install SSMS as well:
   https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 -- Free Download for SQL Server
   Management Studio (SSMS) 18.12.1 (SSMS-Setup-ENU).
6. Restart the computer again and launch Microsoft SQL server management 2019.

Additionally, please refer to the below links which might help in your case:

https://stackoverflow.com/questions/19538089/wait-on-the-database-engine-recovery-handle-failed-check-the-sql-server-error-l

https://www.youtube.com/watch?v=MrntM5uALZQ

If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Thank you.

Answer 3

1. Run Power Shell as administrador.
2. Enter command: New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"
3. After that run next command: Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes"
4. Reboot the PC.
5. Install SQL Server.

Answer 4

Shakti's answer is not really on the mark.

The error message means that SQL Server did not start when Setup wanted to run configuration. To find out why, you need to look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL$MSSQLSQLSERVER07\MSSQL\LOG\ERRORLOG.

If you find a message towards the end about 256 misaligned reads, you are hitting a known issue for which Microsoft has published this article with workarounds.

If you don't see this message, feel free to upload the errorlog file here. You will need to rename it to ERRORLOG.txt for it to be accepted by the forum software.

Answer 5

I had the same problem, then I got this guide from stack overflow, followed the steps using the registry and it worked https://stackoverflow.com/questions/73963436/unable-to-install-sql-serversetup-exe-exit-code-decimal-2061893606/77740453#77740453