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?
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.
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
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.
b ii) On the Edit menu, point to New, and then select Multi-String value. Name it ForcedPhysicalSectorSizeInBytes.
b iii) Modify the new value, type in * 4095. Click OK and close the Registry editor.
b iv) Then restart the computer.
3) Now, you may reinstall SQL Server. It is recommended to install SQL Server 2017 and above for Windows 11.
** Learn more about Azure Cloud
** Learn more about QNE Hybrid Cloud Software
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article