Error while Installing SQL Server 2019

Question

Hi i have an error while installing SQL Server 2019 .

This is what it pops up when the installation is finished

Here is the summary and Detail file:

Detail.txt

Summary_Petar_20230523_185611.txt

Thank you for your help!

Answer 1

The error about wait for the Database Engine recovery handle means that SQL Server did not start when Setup wanted to run configuration. There can be multiple reasons why this happens.

To understand why, you need to do as the message says: look in the SQL Server errorlog. You find it C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\LOG\ERRORLOG.

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