Windows 11 SQL Server install error Wait on the Database Engine Recovery Handle Failed

S Dineshkumar 1 Reputation point
2022-12-27T14:14:32.197+00:00

In Windows 11 Machine, unable to install SQL server 2019. I tried multiple versions. but got the following error message. I tried multiple times and restart the machine. nothing worked out. Please somebody help with this.

Edition Windows 11 Enterprise
Version 21H2
Installed on ‎8/‎24/‎2022
OS build 22000.1335
Experience Windows Feature Experience Pack 1000.22000.1335.0
System type 64-bit operating system, x64-based processor

274295-sql-server-2019-2.png
274276-sql-server-2019-1.png

274287-error-log.txt

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,866 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Bjoern Peters 8,856 Reputation points
    2022-12-27T14:25:20.823+00:00

    Hi @S Dineshkumar

    This error is a known problem and is described in the following documentation:

    https://learn.microsoft.com/en-us/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size?WT.mc_id=DP-MVP-5440

    I hope my answer is helpful to you,

    Your
    Bjoern Peters

    If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

    2 people found this answer helpful.

  2. Erland Sommarskog 102.2K Reputation points MVP
    2022-12-27T22:19:27.393+00:00

    Bjoern may be right. But he is shooting too quick. The error message means that SQL Server did not start when Setup wanted to run configuration items. There are multiple reasons why this can happen. The issue that Bjoern mentioned is just one of them. You need to find certainty before you try it.

    To find out why SQL Server did not start, check the file C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\ERRORLOG (assuming a default installation). If you find a message about 256 misaligned reads, you have the issue that Bjoern had in mind.

    0 comments No comments

  3. Seeya Xi-MSFT 16,451 Reputation points
    2022-12-28T04:31:43.35+00:00

    Hi @S Dineshkumar ,

    As your summary.txt recording, Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Also I would like to mention that if you don't need all the features, you can install them on demand.

    I tried multiple times and restart the machine. nothing worked out.

    Did you follow the steps to uninstall the failed installation and reinstall it?
    Please follow the below steps to remove all components of previous installed SQL Server completely:

    1. Remove all SQL Server components from 'Programs and Features'
    2. Backup the registry
    3. Delete the following keys in regedit:
      --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
      --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
    4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
    5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
      6. Reboot the machine
      In addition, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

    Best regards,
    Seeya


    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.


  4. S Dineshkumar 1 Reputation point
    2022-12-28T11:27:16.093+00:00

    On my laptop, I don't have the privilege to run the registry scripts. I am trying my IT team to run the scripts.


  5. Alok Jha 0 Reputation points
    2024-05-04T17:42:37.73+00:00

    Fixed the issue. Please click on this link https://youtu.be/tlf1kQOzQjw

    0 comments No comments