Share via

Unable to install SQL Server 2019 on Windows 11 - Exit Code(Decimal): -2061893606

Đạt Bùi Tiến 0 Reputation points
2023-09-13T01:11:20.28+00:00

Screenshot 2023-09-13 080643

i can't install SQL server 2019..

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,948 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,086 Reputation points MVP
    2023-09-13T01:32:50.1533333+00:00

    Please open the Windows registry and do the following:

    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. Select OK and close the Registry editor.

    For more information, please visit this support article.

    2 people found this answer helpful.
  2. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-09-13T01:41:18.3966667+00:00

    Hi @Đạt Bùi Tiến

    Please check the logs and provide more details such as Summary log, Detail log and Error log. Their general path is %programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log.

    If you find the error "There have been 256 misaligned log IOs which required falling back to synchronous IO ", then this is a known issue of Windows 11, you can refer to this link: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size?WT.mc_id=DP-MVP-5440.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments
  3. Erland Sommarskog 102.5K Reputation points
    2023-09-13T21:53:35.4366667+00:00

    The message Wait on the Database Engine recovery handle failed is a generic error that means that SQL Server did not start when Setup wanted to run configuration steps. To understand why it did not start, you need to look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG. Note that the component MSSQL16.MSSQLSERVER is for a default instance of SQL 2022. If you are trying to install an older version or a named instance, this component will have a different name.

    If you see a message about 256 misaligned reads, you are running into a known issue where Windows 11 for some disk drives reports a sector size that SQL Server does not cope with. Microsoft has published an article with workarounds for the problem.

    If you don't see the message about misaligned reads, feel free to upload the errorlog here, so we can look at it. You will need to rename to ERRORLOG.txt for the forum software to accept it.

    0 comments