SQL Server : installation fails with error code 0x851A001A

Question

Hi,

I am trying to install SQL server 2019 on my PC but I get the error in question.

how can i solve it?

Thanks,

Summary_PC-Fabiana_20230705_104151.txt

Answer 1

I see this message in the log file:

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

This is a generic message that informs us that SQL Server did not start when Setup wanted to run configuration actions.

To understand why it fails, you need to check the SQL Server errorlog (as it says in the message). You find it C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

If you see a message about 256 unaligned reads towards the end of the file, you are encountering a known issue where Windows 11 reports a disk-sector size that SQL Server cannot cope with. Microsoft has published an article with workarounds for this problem.

If you don't see anything about 256, feel free to upload the ERRORLOG file here. (You will need to rename it to ERRORLOG.txt for it to be accepted.)

Answer 2

Hi @Fabiana Palmisano

Based on the error message, I found a post that encountered the same error, you can refer to it.

https://stackoverflow.com/questions/71003281/sql-server-installation-fails-with-error-code-0x851a001a-wait-on-the-databas

If this can not help you, you need to check the error log according to Erland's advice.

Best regards,

Percy Tang