while installing the sql server 2022 i am getting an error

shanta swaroop 0 Reputation points
2024-06-10T11:57:09.7833333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,045 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,451 Reputation points
    2024-06-10T12:01:55.1033333+00:00

    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

    0 comments No comments

  2. Erland Sommarskog 103.1K Reputation points MVP
    2024-06-10T21:15:16.7166667+00:00

    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.

    0 comments No comments

  3. MikeyQiaoMSFT-0444 1,085 Reputation points
    2024-06-11T09:43:01.17+00:00

    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.

    0 comments No comments