In this guide, we will learn to troubleshoot on issue where Microsoft SQL Server fails to install Database Engine Service in some modern Windows 11 devices.
| Info |
|---|
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
...
Symptoms
When you are installing Microsoft SQL Server on a Windows 11 device, the installation fails at Database Engine Service.
...
To determine if your device suffer from the following issue, you may use run the following command on an elevated command prompt to check if your device will encounter this issue:
...
If the results for PhysicalBytesPerSectorForAtomicity, PhysicalBytesPerSectorForPerformance, or FileSystemEffectivePhysicalBytesPerSectorForAtomicity is any values other than 512 or 4096, you will encounter issue installing Microsoft SQL Server.
Following is an example of a laptop suffering from such issue:
...
On a working device, the following will be the output:
...
be the output:
...
Solution
Open an elevated command prompt by searching for cmd in Start Menu, then right click and select Run as Administrator.
Click copy and execute the following command:
| Code Block |
|---|
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f |
The following should be the output:
...
After this, restart the computer and try installing Microsoft SQL again.
| Note |
|---|
If you have previously installed Microsoft SQL Server but encountered issues, please consider removing the failed instances using the following guide: |
...
Additional Resources
...