Do what the error message says, review SQL Server ErrorLog file for more details, see
3 answers
Sort by: Most helpful
-
-
Erland Sommarskog 112.7K Reputation points MVP
2024-06-03T21:38:32.2933333+00:00 The message "Wait on the database enginer recovery failed" is a generic message which means that SQL Server did not start when Setup wanted to run configuration steps.
To understand why, you need to look in the SQL Server errorlog, which you find in C: \Program Files\Micrsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRRORLOG.
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 disk sector size that SQL Server cannot cope with. Microsoft has published an article with workarounds for the problem.
-
MikeyQiaoMSFT-0444 3,190 Reputation points
2024-06-04T01:46:27.7033333+00:00 Hi,Cydrx Malla
Welcome to the Microsoft SQL Server Q&A forum!
We need the detailed information from the log files to help you locate the problem more accurately. They are usually located as shown in the screenshot below. Be sure to select the file with the latest timestamp.