This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Hello,Cydrx Malla how is your issue going? We are still waiting for your reply and are always ready to provide assistance.
Do what the error message says, review SQL Server ErrorLog file for more details, see
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
alright thank u
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.
ill go have a check, thank you erland ong
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.
Hi，Cydrx MallaHey there! Just checking in on how your issue is going. We're looking forward to your reply and hope to help you out further.
Hey Mikey, it's me cydrx sorry for not replying I gave up on the problem since it was too much work tho I'm back for help
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 50%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
@MikeyQiaoMSFT-0444 i have found the txt.
problem resolved!! btw, if you're also having the same problem as I do, there's a solution to this. Just follow this:https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size?tabs=registry-editor
Shout to this guy, perks on giving step-by-step tutorial https://youtu.be/zChu5Xp4Ysc?si=VfyEScIcGXkZo2KT on bro 🙏😭