question

PriyanshuSingh-9911 avatar image
0 Votes"
PriyanshuSingh-9911 asked AbhishekKesiraju commented

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

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

sql-server-generalazure-sql-databaseazure-sqldatabase-edge
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

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/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AndersBurla-6007 avatar image
0 Votes"
AndersBurla-6007 answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DanGuzman avatar image
3 Votes"
DanGuzman answered AbhishekKesiraju commented

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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!

0 Votes 0 ·

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.

0 Votes 0 ·