SQL Server Installation Issue on Windows 11

If you have recently upgraded your windows 10 to 11 or got new windows 11 based laptop and trying to install SQL Server on local machine you would get a message that Installation Failed. This is known issue with Windows 11 as per here.

Solution

1. Command Prompt as Administrator

Add the key.

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

Validate if the key was added successfully.

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

2. PowerShell as Administrator

Add the key.

New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name   "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString        -Force -Value "* 4095"        

Validate if the key was added successfully.

Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name   "ForcedPhysicalSectorSizeInBytes"