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. Feel free to upload the file. To be able to attach it here, you will to rename it to ERRORLOG.txt.
I cannot install the SQL Server 2022 Developer Edition
I cannot install the SQL Server 2022 Developer Edition (x64) on the Microsoft Windows 10 Pro (10.0.19045). The Database Engine Services failed to install. Please see error messages and exit codes below:
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
Exit code (Decimal): -2061893606
Detailed results:
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x851A001A
Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Windows 10
SQL Server
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T16:01:24.6+00:00 -
Rafal 25 Reputation points
2024-11-24T16:28:23.1+00:00 Thank you for your answer. Please see the .txt files attached. Summary.txt
-
Rafal 25 Reputation points
2024-11-24T16:28:59.5466667+00:00 Please see the config file.
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T16:35:12.5333333+00:00 But that was not the file I was asking for. Then again, here you get a different error than you had in your first post. That may be due to that you made a new attempt, and the old attempt gets in the way.
It seems that you attempted this after you accepted my answer. Did you look in the SQL Server errorlog and drew some conclusion? If not, please share it.
Since you now seem to be failing with a different error, we also need to see detail.txt, which is in the same folder as the summary file.
-
Rafal 25 Reputation points
2024-11-24T19:11:19.85+00:00 Please see .txt files. config.txt
-
Rafal 25 Reputation points
2024-11-24T19:12:36.01+00:00 Please see detail.txtdetail.txt
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T19:16:59.08+00:00 I've told you twice to attach the SQL Server errorlog. If you don't supply the information you ask for, we can't help you.
Details.txt appears to be incomplete.
-
Rafal 25 Reputation points
2024-11-24T19:17:46.8133333+00:00 Please see the log file summary.txt
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T19:20:15.34+00:00 You have already shared that file. But I've been asking for
C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG
a couple of times now. -
Rafal 25 Reputation points
2024-11-24T19:24:07.6433333+00:00 Detail.txt Detail.txt
-
Rafal 25 Reputation points
2024-11-24T19:26:17.53+00:00 There is no error log file in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL. The only sub-folders are Install and Binn
-
Rafal 25 Reputation points
2024-11-24T19:33:21.21+00:00 The "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes." is no more present after restart. I have just share all files I have in accordance with the SQL Server communication. The source folder is C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T19:38:40.22+00:00 Setup now fails at an earlier stage than it before. The fact that you don't have an errorlog (which you have 99 times out of 100 when you get the error message about the recovery handle), makes me think that you deleted files manually or performed some other form of cleanup. This is likely to be the cause for Setup failing now.
Try to follow the instructions in https://www.sql-easy.com/learn/how-to-uninstall-sql-server/. I have never used it myself, but I learn about this post from a user who had installation issues but who successful after following the instructions in this article.
I looked at the detail.txt and the error is related to the Browser service. I have seen it before, but I don't know the solution to it.
-
Rafal 25 Reputation points
2024-11-24T19:42:20.5366667+00:00 After "Repair" the error log is
Error installing SQL Server Database Engine Services Instance Features The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T19:46:37.3833333+00:00 As I said, try to follow that article. I realise that it can be difficult - I have never had to pursue that task myself.
It could be that your machine is really messed up at this point. Maybe there is a System Restore point you can go back to?
Else the alternative is create a virtual machine and run SQL Server on the VM. If you have never worked with virtual machines before there is certainly a hurdle. But virtual machines is a technology which is very useful in itself, so there is a benefit in learning beyond just installing SQL Server.
-
Rafal 25 Reputation points
2024-11-24T20:31:19.45+00:00 I have already uninstalled all SQL components except of Active Directory Authentication Library for SQL Server (x86) and Microsoft SQL Server 2012 Command Line Utilities that I do not see on intalled apps list in Control Panel. How I can uninstall them both?
-
Erland Sommarskog 113.1K Reputation points • MVP
2024-11-24T21:23:44.8066667+00:00 Did you check out the article I pointed you to? I don't know if they are discussed that article. As as matter of fact, I don't recognise the name of these two. What is important is that you don't have remnants in the registry that trips Setup.
-
-
Rafal 25 Reputation points
2024-11-25T14:25:32.77+00:00 Logfile: Summary_RAFAL_20241125_150916.txt
-
Rafal 25 Reputation points
2024-11-25T14:26:10.4133333+00:00 Detail:
-
Rafal 25 Reputation points
2024-11-25T14:29:15.7233333+00:00 Config: ConfigurationFile.txt
-
Rafal 25 Reputation points
2024-11-25T14:30:10.84+00:00 I try to install the MS SQL Server 2017 as it was installed on my PC some years ago.
-
Rafal 25 Reputation points
2024-11-25T14:31:44.97+00:00 Do you know what can be the problem? All SQL Server components were removed, the register was cleaned, all folders were removed, the PC was restarted plenty of times, etc.
-
Rafal 25 Reputation points
2024-11-25T15:17:02.91+00:00 If you try to repair it, the following error message is visible:
The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
Sign in to comment -