SQL Server 2022 Dev Edition Installation error

Question

Hello everyone.

I'm having issues trying to install SQL Server 2022 Developer Edition on my machine. This is for an assignment from school so this is the first time I'm dealing with SQL. The issue is that the Database Engine Service is not installed properly "Error details: Error installing SQL Server Database Engine Services Instance Features. Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Error code: 0x851A001A"

I checked the summary and I cannot understand properly what is the issue. I've been going back and forth with this since Monday. What I first did was to do the Basic install. Then I went with the custom mode and Installed only Core services/features. Before moving between installations I deleted all traces of SQL. I even rebooted from factory the machine. I had a warning in the Fiewall validation so I opened port 1433 as I understand is the default one for SQL but still got the warning. Could that be the problem? I'm attaching the summary, please let me know if further information is required.

Thank you!

Answer 1

Hi @Guillermo Ezequiel Chehda，

If you are using Windows 11, there is a known issue when you install sql server 2022 on Windows 11.

Try one of the resolutions in this article.

If this do not work, in the folder C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log there is one folder per install attempt.

The one of most interest is Detail.txt. Feel free to attach it here.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hello everyone, I tried every solution posted before creating the post, and I was unable to install it on my computer. UNTIL: I was talking to a friend about this issue and the solutions, and he asked me if I had tried to download the file again and try to install it on my computer and my wife's. Before that, I tried to have a "clean install" with the files available to provide the Details.txt. The files are the same, so why should I do that? So, all grumpy I downloaded the file again from the Microsoft Official Website. I sent the same link to my wife and guess what, yeah... it worked!! IN BOTH COMPUTERS.

Thank you for all your contributions. I tried the solutions, and I was not expecting that this worked.

Answer 3

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.

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 4

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes

Do what the error message say, check ErrorLog, see

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