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

Question

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

Priyanshu Singh 36

SQL Server 2019 install error Wait on the Database Engine Recovery Handle Failed this error is coming and i have tried everything on the internet to solve this but it still isnt installing can anyone tell me how to remove this error

Anonymous

2022-02-23T11:06:23.997+00:00

We have a developer laptop (Lenovo T14 Gen2) running windows 11 where this error happens, and none of the solutions work. Tried running windows 10 on the same machine and install SQL 2019 and all works. On windows 11 it doesnt even when windows is fully updated and SQL is the first program we install after a clean windows 11 install. Any ideas of how to fix this?
Bhamidipati Subrahmanya Aditya 1 Reputation point

2022-12-14T19:32:25.157+00:00

same issue I'm also facing..
Win11 64bit
is this still on, any solutions for this..??
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-12-14T21:54:33.557+00:00

What issue? The error message in the title is a generic message, and there multiple possible underlying causes.

Check the SQL Server errorlog (see my post above). If you see a message about 256 unaligned I/Os, this is a known issue, and see this Microsoft article for workarounds.

Else start a new thread where you describe your problem from start to end. Don't forget to include the SQL Server errorlog.
Bhamidipati Subrahmanya Aditya 1 Reputation point

2022-12-15T07:35:00.153+00:00

Hi, I have uninstalled sql server and cleared the registry and sql server folder from program files as well, havent copied the error msg.
"Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes" this was displayed at on the msi installer wizard at last.
later restarted the system and tried installing again, same error appeared installation failed

![270907-screenshot-2022-12-15-130340.png][2]
Anonymous

2022-12-15T07:37:37.777+00:00

Run this command (in admin mode) to see if the 'PhysicalBytesPerSectorForAtomicity' is <= 4096
fsutil fsinfo sectorinfo C:

If its > 4096 then run this command in PowerShell (in admin mode).
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"

Restart and try clean install again. Worked for us
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-12-15T21:50:58.967+00:00

Again: start a new question, and don't piggyback on old threads.

And don't forget to include the SQL Server errorlog. (Again see my post above for where to find it.)
Damanjot singh 25 Reputation points

2023-01-19T14:57:27.6166667+00:00

I have a (lenovo ideapad gamming 3)amd rayzen and Running in Windows 11 version laptop .When I Install SQL Server But my Data base engine gettting failed its Just Giving

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-01-19T22:09:57.4966667+00:00

Piggybacking on old threads is not a good idea. The recommendation is that you ask a new Question.

However, check the file C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\ERRORLOG (the exact path depends on your version and edition. This is the path for SQL 2019 Developer Edition.) If this file has a message towards the end baout 256 misaligned reads and synchronous mode, you are running into a known issue, and you should read this troubleshooter from Microsoft.

If you don't see this message, ask a new Question. Be sure attach the ERRORLOG file with the post.
Naomi Nosonovsky 8,431 Reputation points

2023-01-19T22:15:37.0333333+00:00

You have an interesting number of reputation points right now, Erland :)
mohamud ahmed 15 Reputation points

2023-03-12T11:07:46.1066667+00:00

i have the same problem with sql server express 2022, and tried everything but nothing.

pls help

i am using windows 11
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-03-12T11:14:03.39+00:00

You can start by helping yourself by actually reading the messages in this thread. Specifically, read my post above.

Jayant Verma 0


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.

Jayant Verma 0 Reputation points

2023-03-21T07:33:44.99+00:00

if any one know how to resolve this please tell
Divyabharathi P 16 Reputation points

2023-03-21T08:07:38.15+00:00

@Jayant Verma sometime already created instances might trouble to install sql server, make sure all old instances are uninstalled before installation sql…… Goto C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER

(uninstall all unnecessary instances) restart computer and try to install it……this might work…
Greg Knierim 0 Reputation points

2023-03-31T21:59:09.6066667+00:00

I just tried installing SQL Server 2022 Developer Edition on my Lenovo Thinkpad G2 and got the same error.

Had a similar issue on a new Dell XPS and it ended up being that the drive that the databases were stored on had BitLocker enabled. Turned off Bitlocker for that drive (it was another drive letter besides C:) and the errors went away. Bitlocker for the Lenovo is not turned on and the registry resolution below doesn't work.
Vilochana Rajapaksha 0 Reputation points

2023-05-14T17:11:43.58+00:00

I have the same problem with SQL Server Developer 2022 and have tried everything but nothing.

I am using a Lenovo Ideapad Slim 5 Pro Ryzen 5 laptop with Windows 11.

Please help!
Dorothy Hawley 0 Reputation points

2023-08-21T17:21:30.02+00:00

The link to the English copy:
https://learn.microsoft.com/en-gb/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size?WT.mc_id=DP-MVP-5440
Fasil Hayat 0 Reputation points

2024-05-05T10:26:26.53+00:00

Installing SQL Server 2019 Enterprise on my developer laptop has been a nightmare. If a single feature fails to be installed, you are left with something that is very hard to reset.

I have numerous attempts removing and re-installing and everytime a new error. From offline R related features not being able to be downloaded, firewall warnings and now to this recent 'error Wait on the Database Engine Recovery Handle failed' error.

I don't want to go through re-installing my Visual Studio 2022. That is simply not worth the effort, since my developer plugins and customized setup will be reset too.

I am very annoyed about this. The installation wizard has also been the same since back in the 00's. I think it should be time for an updated and more resilient installation experience.

7 answers

Your answer

Anonymous

2022-02-23T11:06:23.997+00:00

We have a developer laptop (Lenovo T14 Gen2) running windows 11 where this error happens, and none of the solutions work. Tried running windows 10 on the same machine and install SQL 2019 and all works. On windows 11 it doesnt even when windows is fully updated and SQL is the first program we install after a clean windows 11 install. Any ideas of how to fix this?
Bhamidipati Subrahmanya Aditya 1 Reputation point

2022-12-14T19:32:25.157+00:00

same issue I'm also facing..
Win11 64bit
is this still on, any solutions for this..??
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-12-14T21:54:33.557+00:00

What issue? The error message in the title is a generic message, and there multiple possible underlying causes.

Check the SQL Server errorlog (see my post above). If you see a message about 256 unaligned I/Os, this is a known issue, and see this Microsoft article for workarounds.

Else start a new thread where you describe your problem from start to end. Don't forget to include the SQL Server errorlog.
Bhamidipati Subrahmanya Aditya 1 Reputation point

2022-12-15T07:35:00.153+00:00

Hi, I have uninstalled sql server and cleared the registry and sql server folder from program files as well, havent copied the error msg.
"Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes" this was displayed at on the msi installer wizard at last.
later restarted the system and tried installing again, same error appeared installation failed

![270907-screenshot-2022-12-15-130340.png][2]
Anonymous

2022-12-15T07:37:37.777+00:00

Run this command (in admin mode) to see if the 'PhysicalBytesPerSectorForAtomicity' is <= 4096
fsutil fsinfo sectorinfo C:

If its > 4096 then run this command in PowerShell (in admin mode).
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"

Restart and try clean install again. Worked for us
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-12-15T21:50:58.967+00:00

Again: start a new question, and don't piggyback on old threads.

And don't forget to include the SQL Server errorlog. (Again see my post above for where to find it.)
Damanjot singh 25 Reputation points

2023-01-19T14:57:27.6166667+00:00

I have a (lenovo ideapad gamming 3)amd rayzen and Running in Windows 11 version laptop .When I Install SQL Server But my Data base engine gettting failed its Just Giving

The following error has occurred:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-01-19T22:09:57.4966667+00:00

Piggybacking on old threads is not a good idea. The recommendation is that you ask a new Question.

However, check the file C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\ERRORLOG (the exact path depends on your version and edition. This is the path for SQL 2019 Developer Edition.) If this file has a message towards the end baout 256 misaligned reads and synchronous mode, you are running into a known issue, and you should read this troubleshooter from Microsoft.

If you don't see this message, ask a new Question. Be sure attach the ERRORLOG file with the post.
Naomi Nosonovsky 8,431 Reputation points

2023-01-19T22:15:37.0333333+00:00

You have an interesting number of reputation points right now, Erland :)
mohamud ahmed 15 Reputation points

2023-03-12T11:07:46.1066667+00:00

i have the same problem with sql server express 2022, and tried everything but nothing.

pls help

i am using windows 11
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-03-12T11:14:03.39+00:00

You can start by helping yourself by actually reading the messages in this thread. Specifically, read my post above.
Jayant Verma 0 Reputation points

2023-03-21T07:33:14.25+00:00

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.
Jayant Verma 0 Reputation points

2023-03-21T07:33:44.99+00:00

if any one know how to resolve this please tell
Divyabharathi P 16 Reputation points

2023-03-21T08:07:38.15+00:00

@Jayant Verma sometime already created instances might trouble to install sql server, make sure all old instances are uninstalled before installation sql…… Goto C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER

(uninstall all unnecessary instances) restart computer and try to install it……this might work…
Greg Knierim 0 Reputation points

2023-03-31T21:59:09.6066667+00:00

I just tried installing SQL Server 2022 Developer Edition on my Lenovo Thinkpad G2 and got the same error.

Had a similar issue on a new Dell XPS and it ended up being that the drive that the databases were stored on had BitLocker enabled. Turned off Bitlocker for that drive (it was another drive letter besides C:) and the errors went away. Bitlocker for the Lenovo is not turned on and the registry resolution below doesn't work.
Vilochana Rajapaksha 0 Reputation points

2023-05-14T17:11:43.58+00:00

I have the same problem with SQL Server Developer 2022 and have tried everything but nothing.

I am using a Lenovo Ideapad Slim 5 Pro Ryzen 5 laptop with Windows 11.

Please help!
Dorothy Hawley 0 Reputation points

2023-08-21T17:21:30.02+00:00

The link to the English copy:
https://learn.microsoft.com/en-gb/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size?WT.mc_id=DP-MVP-5440
Fasil Hayat 0 Reputation points

2024-05-05T10:26:26.53+00:00

Installing SQL Server 2019 Enterprise on my developer laptop has been a nightmare. If a single feature fails to be installed, you are left with something that is very hard to reset.

I have numerous attempts removing and re-installing and everytime a new error. From offline R related features not being able to be downloaded, firewall warnings and now to this recent 'error Wait on the Database Engine Recovery Handle failed' error.

I don't want to go through re-installing my Visual Studio 2022. That is simply not worth the effort, since my developer plugins and customized setup will be reset too.

I am very annoyed about this. The installation wizard has also been the same since back in the 00's. I think it should be time for an updated and more resilient installation experience.

Answer 1

Dan Guzman 9,401

We have a developer laptop (Lenovo T14 Gen2) running windows 11 where this error happens, and none of the solutions work.

Try the solutions discussed in this Microsoft article: Troubleshoot errors related to system disk sector size greater than 4 KB. There are known issues with SQL Server on Windows 11 with some storage devices.

Ian Haigh 1 Reputation point

2022-02-24T14:30:36.243+00:00

Thanks Dan for the link to this. I had the same issue as Anders (even down to the same PC!). The link you sent through helped and after following the steps allowed SQL Express to be installed!
Abhishek Kesiraju 1 Reputation point

2022-03-01T07:37:30.213+00:00

Newer Windows 11 systems tend to have system disk sector size greater than 5Kb ... I'm glad microsoft released this article, was cursing my new laptop for months because of this error. The above article has commands that allow us to change disk sector size reading, which helps.
Mluleki Memela 0 Reputation points

2024-07-29T10:24:39.9733333+00:00

Make sure you run fsutil fsinfo sectorinfo C:/D:( whatever your drive is) command to see if there is an issue before you add the new key suggested in the Microsoft article, then backup your registry keys(in case errors occur when making a change) with Registry Editor(search "registry editor on Start) if there is a issue and export it first using How to backup and restore specific Registry keys on Windows 11 article as a guide on how to do it.

You'll notice that the file path is "~\Services\stornvme\Parameters\Device" on the Troubleshoot errors related to system disk sector size greater than 4 KB article so just use Registry Editor to navigate to the HKLM (stands for "HKEY_LOCAL_MACHINE") until it matches the file path and export the stornvme or Parameters folder(see article above on how to export backup as a .reg file). Once backed up/saved as a .reg file somewhere, open command prompt run as administrator, copy paste the "REG ADD..." command on command prompt, and RESTART( change won't take effect until you restart) your computer. It should be able to install now. This is what helped me with 1. Adding .mdf file on visual studio 2019 (I was getting errors because disk sector size was greater than 4 KB) and 2. Installing sql server express. Good luck.
GUILLERMO VITOLA 5 Reputation points

2025-03-23T15:12:16.38+00:00

This was exactly the root cause of the failure in my case!!! Thank you. I was working on that since yesterday and I was trying to many other alternatives I found before without any success.

Answer 2

Recently I faced the same issue saying database engine recovery failed while installing SQL server 2019 developer version on windows 11
After so many trial and error methods, I was able to install SQL server on windows 11.

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
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.
I know it doesn't make sense still I uninstalled visual studio 2022 as well - it may be optional I just wanted to install SQL.
Restart the computer (you must)
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)
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).
Restart the computer again and launch Microsoft SQL server management 2019.
Hope it helps. Thank you.

Ramesh Vagganavar 15 Reputation points

2023-01-25T05:03:30.31+00:00

@DIVYABHARATHI P The above solution works. Thumps up
Gabriela Wanat 0 Reputation points

2024-01-05T17:53:47.0266667+00:00

I will genuinely cry, thank you so much!!!! After weeks of solution seeking, your steps and emulation of the sector size using registry key made it possible for me to install SQL Server <3
Chammmppp 0 Reputation points

2025-04-23T13:23:32.24+00:00

Thank you, It's work for me

Answer 3

Cris Zhan-MSFT 6,661

Hi,

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

The following article details the possible causes and solutions to this problem. Basically, you need to ensure that SQL server is completely cleaned without leaving any residue(including folders and registry), and then always right-click the installation file(setup.exe) and select "run as administrator" to start the installer, and select the startup account of the database engine service as the NT authority \ system (local system account) during installation.
https://www.mssqltips.com/sqlservertip/4526/sql-server-install-error-wait-on-the-database-engine-recovery-handle-failed/

Garry Young 0 Reputation points

2025-05-20T13:34:23.1033333+00:00

Database Engine as 'NT authority \ system' worked for me. Thanks

Answer 4

Olaf Helper 47,436

See MS TechNet Wiki: SQL Server Troubleshooting: Could Not Find Database Engine Startup Handle Error During installation

Answer 5

Erland Sommarskog 121.4K MVP Volunteer Moderator

You need to look at the SQL Server error log, which should be in C:\Program Files\Microsoft SQL Server\MSSQ15.MSSQLSERVER\MSSQL\LOG\Errorlog (assuming a default installation). The problem is that SQL Server does not start. The errorlog may tell you why.

Alex Arias 0 Reputation points

2023-02-19T22:12:29.3166667+00:00

En el video del siguiente link encontré la solución.

Se debe ejecutar esta línea en CMD ejecutado como Administrador:

REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f

Espero les sirva!
Link: https://youtu.be/iv1miBdjCRw

Share via

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

7 answers

Your answer