marwen froua 0 Reputation points


I tried installing SQL SERVER 2022 before installing 2019 version but i had the same problem, im running on windows 11 , i already tried changing the registry for the sector size to * 4095 but in vain heres my log file and the screenshotUser's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,576 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 92,956 Reputation points

    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\MSSQL15.SQLEXPRESS\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.

    Since you say that you have already changed the disk-sector size, you are maybe running into something else. 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.

    0 comments No comments

  2. CosmogHong-MSFT 17,081 Reputation points Microsoft Vendor

    Hi @marwen froua

    How about start SQL Server by specifying the trace flag 1800. For more information, see DBCC TRACEON. This trace flag isn't enabled by default. Trace flag 1800 forces SQL Server to use 4 KB as the sector size for all read and write operations. When you are running SQL Server on disks with physical sector size greater than 4 KB, using the trace flag 1800 will simulate a native 4 KB drive, which is the supported sector size for SQL Server.

    Best regards,

    Cosmog Hong