Search code examples
sqlsql-serverdatabasesql-server-2019

Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606

This is what happens when the installation is completed.

I've tried deleting every residual file from previous installations and I've even restarted my laptop and tried installing the express version as well, but I got the same results.

enter image description here

For those who can't open the image. "Error description: Wait on Database Engine recovery handle failed.Check the Sql Server error log for potential causes."

Solution

  • https://learn.microsoft.com/en-us/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size

    Followed next info from link above:

    Registry Editor

    1. Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device.
    2. On the Edit menu, point to New, and then select Multi-String value. Name it ForcedPhysicalSectorSizeInBytes.
    3. Modify the new value, type in * 4095. Click OK and close the Registry editor.

    Command Prompt as Administrator

    1. Add the key. Console
    REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t   REG_MULTI_SZ /d "* 4095" /f
    1. Validate if the key was added successfully.
    REG QUERY "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes"

    PowerShell as Administrator

    1. Add the key.
    New-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" Name   "ForcedPhysicalSectorSizeInBytes" -PropertyType MultiString Force -Value "* 4095"
    1. Validate if the key was added successfully.
    Copy Get-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" -Name   "ForcedPhysicalSectorSizeInBytes"