1. First add key in registory editor 2.Command Prompt as Administrator 3.Add key REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f 4. Validate if the key was added successfully. REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" 5. After that reboot system. 6. Download sqlserver 2022 exe from Microsoft official website
What a messy and confusing long video full of misclicks - just to add a registry key. Could have been boiled down to half a minute.
1. First add key in registory editor
2.Command Prompt as Administrator
3.Add key REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f
4. Validate if the key was added successfully.
REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes"
5. After that reboot system.
6. Download sqlserver 2022 exe from Microsoft official website