Do what the message says: Viewing the SQL Server Error Log for more details.
Unable to install SQL Server
I'm trying to install SQL Server 2022 but it keep pop on this noti :
Unable to install SQL Server (setup.exe)
Exit code (Decimal): -2061893606Error descsription : Wait on the Databse Engine recovery handle failed.
Does anyone know the issue.
Thank you
4 answers
Sort by: Most helpful
-
-
RahulRandive 9,666 Reputation points
2023-09-19T10:12:15.79+00:00 Hi @Huy Luong
The 'Wait on the Database Engine recovery handle failed' message is a general error indicating that SQL Server didn't start as expected during the Setup configuration steps.
To diagnose why it failed to start, you should check the SQL Server error log located in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG. Please note that the 'MSSQL16.MSSQLSERVER' component is associated with the default instance of SQL Server 2022.
Also, please refer to this blog for more solutions https://www.mssqltips.com/sqlservertip/4526/sql-server-install-error-wait-on-the-database-engine-recovery-handle-failed/
Thank you!
-
Erland Sommarskog 111.4K Reputation points MVP
2023-09-19T21:44:29.5666667+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.SQLEXPRESS\MSSQL\LOG\ERRORLOG.
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.
-
PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
2023-09-20T01:55:28.6066667+00:00 Hi,
The error message you provided is too vague. We cannot provide effective help. Please provide the error log according to this link.
Best regards,
Percy Tang