Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

Natalia Medrano 0 Reputation points
2024-05-10T07:45:13.2366667+00:00
  • I have been trying to run kestrel in Visual Studio, and then I got this message:

System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start.

))'

  • Then, I checked if the SQL is running in the services, and I only have SQL Server VSS Writer (which is running).
  • So, then I installed SQL Server 2019, and I got the error of unable to install SQL server.
  • So, I went to the logs, and I have this message:

There have been 256 misaligned log IOs which required falling back to synchronous IO.

What should I do to fix this bug? I have lost two days of work because I just cannot run the backend because one issue brings another issue. It is like a snowball that just keeps growing.

Can someone help me? I would be very very very grateful.

Thank you

//Natália

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,947 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,290 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 44,931 Reputation points
    2024-05-10T11:09:38.3666667+00:00

    There have been 256 misaligned log IOs which required falling back to synchronous IO.

    A known issue in combination of Win 11 and some SSD disks, see

    https://techcommunity.microsoft.com/t5/running-sap-applications-on-the/message-misaligned-log-ios-which-required-falling-back-to/ba-p/367796

    0 comments No comments

  2. Erland Sommarskog 112.5K Reputation points MVP
    2024-05-10T21:43:14.7433333+00:00

    This is a known issue. This article gives you a couple of workarounds.

    0 comments No comments

  3. MikeyQiaoMSFT-0444 3,190 Reputation points
    2024-05-11T08:07:00.82+00:00

    Hi,Natalia Medrano

    Welcome to microsoft Q&A, Thankyou for posting your query here.

    Based on the information you've provided, it can be inferred that this is a known issue. The answers to Olaf and Erland will be of help to you.

    If, after trying, there is no effect, please let us know.


    If the answer is helpful to you, don't forget to accept it.This will help many people who have had similar experiences to yours.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.