[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Wait on the Database Engine recovery handle failed

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Wait on the Database Engine recovery handle failed.


Applies to: Microsoft SQL Server 2019/2022 on Windows 11/Windows 10.

Date created: November 22, 2022.
 

Problem Description.
 

After installing SQL Server on your computer you receive an error saying SQL Server fails to start.

When you examine the Summary.txt log file created by SQL Server setup program, you get the following errors:

 

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.

Feature: SQL Server Replication
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
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.

Feature: Client Tools Connectivity
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Common Files
Component error code: 0x84BB0001
Error description: The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.

 

Workaround/Solution.


This could be related to a known issue related disk sector size greater than 4 KB. As a solution make the following changes on the Registry:

  1. Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.
  2. On the Edit menu, point to New, and then select Multi-String value. Name it ForcedPhysicalSectorSizeInBytes.
  3. Modify the new value, type in "* 4095". Click OK and close the Registry editor.

If the issue is not related to above mentioned issue, you can try running the following command using the Command Prompt from the drive where SQL Server media is located.

setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=domain_or_computer\YourWindowsAccount /SAPWD=sapassword /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.