Pos3/5/FNB: Install SQL server failed, and database engine failed to start?

Question :

Install SQL server failed and database engine failed to start

Possible Reason :

For systems running on Windows 11, some new storage devices and device drivers will expose to 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.

Solution :

1. Click on the Windows button and select Run… or use the combination of controls Win+R to open the Run window.

2. Type in “cmd” (without quotes) in the Run window.

3. Remember that the command prompt must be run as administrator.

4. Add the key

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

5. Validate if the key was added successfully.

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

6. Restart the computer and you will be able to start SQL server service.

By: Kee 20230319, Jacky 20230323, P230323 [000395]

Pos3/5/FNB: Install SQL server failed, and database engine failed to start?

Go to menu