Unable to Install SQL Server in Windows 11



Prompt error message when installing SQL Server 2008r2, 2012, 2014, 2017, 2019

1) Wait on the database engine recovery handle failed

2) could not find the database engine startup handle





Cause

Windows update causing the system disk greater than 4kb



Solution

Run the registry below using command prompt (run as administrator)

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



To check whether added

REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes"




The restart the PC and try to install SQL server again




Ref: https://learn.microsoft.com/sv-se/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size?WT.mc_id=DP-MVP-5440

(please do change to english as the article was in sweedish)



https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size