SQL Server Express edition install error (Decimal code)

Question

I Try to install SQL server and this happens. Tried rebooting the pc, tried 2019 version, same error, found nothing about it. Please someone save me here

Answer 1

The message about the database startup handle, means that SQL Server did not start when Setup needed to run configuration.

To find out, do as the error message says: look at the SQL Server errorlog. You find it in C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

If you see a line towards the end of the file about 256 misaligned reads, you are running into a known issue with SQL Server and Windows 11. Microsoft has published an article which suggests a couple of workarounds: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size.

Answer 2

Hi @Lucas Panucci ,

As Erland said, you need to check the errorlog for the following reported errors.

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

Also, I'll add a link.

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

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".