How to fix Care Control Windows error: “SQL Service not starting”
You can fix the SQL Service not starting error by trying one of the three methods below. Usually only one method is required, but try all three if needed.
PowerShell Method
- Run PowerShell as an administrator.
- Run the following command to add the key:
Copy to clipboard
New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString -Force -Value "* 4095"Run the following command to validate if the key is added successfully:
Copy to clipboard
Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name "ForcedPhysicalSectorSizeInBytes"Then restart.
Registry Editor Method
- Run Registry Editor as an administrator.
- Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.
- Select Edit > New > Multi-String value and name it as ForcedPhysicalSectorSizeInBytes.
- Right-click the name, select Modify, and type * 4095 in the Value data field.
- Select OK and close Registry Editor.
You must reboot the device after adding the registry key for this change to take effect.
Command Prompt Method
- Run Command Prompt as an administrator.
- Run the following command to add the key:
Copy to clipboard
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f- Run the following command to validate if the key is added successfully:
Copy to clipboard
REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v
"ForcedPhysicalSectorSizeInBytes"