while installing the sql server 2022 i am getting an error

Question

exit code(Decimal): 2061893606 Error Description: wait on the database engine recovery handle failed. check the sql server error log for potential causes

Getting this error while installing sql

Answer 1

Hi，shanta swaroop

Welcome to Microsoft Sql Server Q&A fourm！

You need to look at the SQL Server installation log details to pinpoint the issue.

The link mentioned by Olaf can help you locate the file position.

Erland has provided you with common causes and analysis for the issue.

You can post the files you find, but remember to mask sensitive information before uploading.

We'll keep an eye on your issue and welcome any updates you've got.

Answer 2

The message Wait on the Database Engine recovery handle failed is a generic error that means that SQL Server did not start when Setup wanted to run configuration steps. To understand why it did not start, you need to look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG. Note that the component MSSQL16.MSSQLSERVER is for a default instance of SQL 2022. If you are trying to install a named instance, this component will have a different name.

If you see a message about 256 misaligned reads, you are running into a known issue where Windows 11 for some disk drives reports a sector size that SQL Server does not cope with. Microsoft has published an article with workarounds for the problem.

If you don't see the message about misaligned reads, feel free to upload the errorlog here, so we can look at it. You will need to rename to ERRORLOG.txt for the forum software to accept it.

Answer 3

check the sql server error log for potential causes

Then do what the error message says and have a look for more details.

https://learn.microsoft.com/en-us/sql/tools/configuration-manager/viewing-the-sql-server-error-log?view=sql-server-ver16