![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Kunj Patel
In the detail.txt you provided, I found an error.
A thread that also reports the error, not sure if it can help you.
Best regards,
Percy Tang
Error while installing any Microsoft SQL Server editions on my windows 11 laptop
![](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(35.2, 57.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kunj Patel
0
Reputation points
Hello Community!
Can someone please guide me on what should I do to fix my MS SQL Server installation for my windows 11 laptop?
Every edition that I install on my laptop results in the same 'Oops' error:
I am attaching the details and summary files here, please let me know if anything else is needed.
Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
-
Kunj Patel 0 Reputation points
2023-10-25T20:25:34.2+00:00 Unfortunately, it will only allow me to upload one file at a time, so here's the detail.txt.
-
Kunj Patel 0 Reputation points
2023-10-25T20:32:37.0133333+00:00 Detail.txt
Unfortunately, it will only allow me to upload one file at a time, so here's the detail.txt.
Sign in to comment
2 answers
Sort by: Most helpful
-
Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator2023-10-25T21:18:13.13+00:00 The message Wait on the Database Engine recovery handle failed is a generic error that means that SQL Server did not start when Setup wanted to run configuration steps. To understand why it did not start, you need to look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\LOG\ERRORLOG.
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 sector size that SQL Server does not cope with. Microsoft has published an article with workarounds for the problem.
If you don't see the message about misaligned reads, feel free to upload the errorlog here, so we can look at it. You will need to rename to ERRORLOG.txt for the forum software to accept it.
-
Kunj Patel 0 Reputation points
2023-10-27T14:10:03.96+00:00 @Erland Sommarskog I see it's the same issue as the 256 misaligned reads. The sector size of my disks are 16K, I tried to reduce it by formatting it, but it still remains the same. Do you know if there's any way to make the sector size for performance go down for the SQL installation to go thru? I tried to add the registry key as well, still no difference.
-
Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator
2023-10-27T20:32:00.5733333+00:00 I have not run into this issue myself, so I have no experience from it. (I was careful to select a different brand that the disk model that causes this problem, when I built my most recent computer.)
Howevre, I am under the impression that most people have been able to resolve the issue with help of that article from Microsoft. I've noticed that some have said that they had to set the sector size to 4095 rather than 4096. I can't say that it makes much sense, but as I said, I have not had reason to try this myself.
If you don't want to play with the registry or change the sector size, you could create a virtual machine in which you install SQL Server, or you could use a Docker container.
Sign in to comment -