Troubleshooting: Windows 11 SQL Server Installation Error-Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes

From AutoCount Resource Center

Question: When I install SQL Server on Windows 11, there is an error message: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential cause.
After I click ‘OK’ on the error, the installation is completed with Database Engine Services and SQL Server Replication failures. The SQL Server Service will not start. Why?

Version: 1.8 / 1.9 / 2.0

Window11sql1.jpg


Window11sql2.png


Possible Reason:

On Windows 11, some storage devices and device drivers will expose a disk sector size larger than 4 KB. In this case, SQL Server unable to start due to unsupported file system as SQL Server currently supports sector storage sizes of 512 bytes and 4 KB.


Solution:

Add a registry key to force the sector size to be emulated as 4 KB in size.

1) Uninstall/Remove all the existing SQL Server from Control Panel.


2) To add the ForcedPhysicalSectorSizeInBytes registry key, you may use Command Prompt (Method a) OR use the Registry Editor (Method b).

Before that, please backup the registry.
(refer link for how to backup registry https://support.microsoft.com/en-us/topic/how-to-back-up-and-restore-the-registry-in-windows-855140ad-e318-2a13-2829-d428a2ab0692#ID0EBD=Windows_11)


Method a: Use Command Prompt

a i) Run the Command Prompt as Administrator.

Window11sql3.png


a ii) Copy and paste the following command, and press Enter

REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f

Window11sql4.png


a iii) Then restart the computer.


Method b: Use Registry Editor

b i) Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.

Window11sql5.png


b ii) On the Edit menu, point to New, and then select Multi-String value. Name it ForcedPhysicalSectorSizeInBytes.

Window11sql6.png

Window11sql7.png


b iii) Modify the new value, type in * 4095. Click OK and close the Registry editor.

Window11sql8.png


b iv) Then restart the computer.


3) Now, you may reinstall SQL Server. It is recommended to install SQL Server 2016 and above for Windows 11.


To download Microsoft SQL Server 2019 Express edition, please click the following link:

https://download.microsoft.com/download/7/c/1/7c14e92e-bdcb-4f89-b7cf-93543e7112d1/SQLEXPR_x64_ENU.exe


4) Under the Server Configuration page, make sure Startup Type for SQL Server Database Engine is Manual or Disabled.

Window11sql9.png


5) The installation should success now.


6) After that, go to SQL Server Configuration Manager, go to SQL Server Network Configuration > Protocols for A2006 (choose the instance name that you installed just now), right click on TCP/IP and select Enable.

Window11sql10.png


Window11sql11.png


7) Go to SQL Server Services, right click on SQL Server (A2006) > Properties > Service, change the Start Mode to Automatic, then click on Apply and OK.

Window11sql12.png


8) Right click on SQL instance and click on Start to start the services.

Window11sql13.png


Note: Please seek assistance from your software dealer if the problem persists after performing the suggested steps.


By: Jodie 220901, Lay Swan 220908, P220926


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations