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

Priyanshu Singh 31

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

Damanjot singh 20 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 101.2K Reputation points MVP

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 7,361 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 101.2K Reputation points MVP

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 11 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

8 answers

Dan Guzman 9,211 Reputation points

2022-02-23T12:05:13.373+00:00

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.
Please sign in to rate this answer.

4 people found this answer helpful.
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.
Sign in to comment
Divyabharathi P 11 Reputation points

2022-08-24T23:59:47.337+00:00
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.
Please sign in to rate this answer.

2 people found this answer helpful.
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
Sign in to comment
Anders Burla 6 Reputation points

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?
Please sign in to rate this answer.

1 person found this answer helpful.
Bhamidipati 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 101.2K Reputation points MVP

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 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]

Anders Burla 6 Reputation points

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 101.2K Reputation points MVP

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.)
Sign in to comment
Olaf Helper 40,901 Reputation points

2021-07-28T12:20:50.487+00:00

See MS TechNet Wiki: SQL Server Troubleshooting: Could Not Find Database Engine Startup Handle Error During installation
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Erland Sommarskog 101.2K Reputation points MVP

2021-07-28T12:57:58.317+00:00

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.
Please sign in to rate this answer.
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
Sign in to comment