SQL Database Installation error on Windows 11

Problem: When installing Stabibase on Windows 11 an error occurs when the installer is trying to install SQL serverexpress as part of the installation.


Solution:

On systems running Windows 11, some new storage devices and device drivers will expose a disk sector size greater than the supported 4-KB sector size.
When this occurs, SQL Server will be unable to start due to the unsupported file system as SQL Server currently supports sector storage sizes of 512 bytes and 4 KB.
step 1 of 3
To check if this is the case, you need to open a console (CMD prompt) as admin and type 
fsutil fsinfo sectorinfo C:

Where C: is the volume that needs to be checked 



Then type:

 fsutil fsinfo sectorinfo C:



step 2 of 3

If the sectorsize is larger than 4KB (4096) you need to adjust it in the console by typing this command:

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


step 3 of 3

It will adjust the register, but you would need to reboot the computer for it to work. Since you're rebooting, allow Windows to update with the latest updates.