exit code decimal: -2061893606 Error description: wait on database engine recovery handle failed

Question

I am not able to install SQL server in my new system, even though I have re-installed the windows, but the issue still persists

Answer 1

The message "wait on the database engine recovery handle" is not the best one, but it means that SQL Server did not start when Setup wanted to run configuration.

To understand why it does not start, check the SQL Server error log, which you find in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG. Note that the exact path depends on what you version and edition of SQL Server you are trying to instsall.

If you see a message towards the end about 256 misaligned reads, you are running into a known issue for which Microsoft has published an article with workarounds. If you don't see that message, feel free to attach the errorlog here. (You will rename it to ERRORLOG.txt for the forum software to accept it.)

Answer 2

Hi @Sumit pratap singh

I am not able to install SQL server in my new system

Are you install SQL Server on Windows 11 or Windows Server 2022? Windows 11 uses different block sizes for disc alignment (32k) which aren't supported by SQL Server.

If yes, then please troubleshoot follow by this: Troubleshoot errors related to system disk sector size greater than 4 KB.

If not, please post the error logs.

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

The path (150) based on the version you installed.

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