cannot install sql server 2022

hemant 0 Reputation points
2024-04-15T13:30:34.41+00:00

sql_error

errorlog.txt

please help

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,470 questions
{count} votes

2 answers

Sort by: Most helpful
  1. S.Sengupta 15,191 Reputation points MVP
    2024-04-16T01:17:43.33+00:00

    While this thread doesn't directly address error code 0x851A001A, it discusses a similar issue related to the Database Engine recovery. Kindly go through the following Microsoft reference article:

    Install SQL Server Database Engine

    0 comments No comments

  2. Molly Lu 761 Reputation points Microsoft Vendor
    2024-04-22T04:59:27.6066667+00:00

    Hello,

    According to the error message, the message"wait on the Database Engine recovery handle failed" indicates SQL server did not start when Setup needed to run configuration actions.

    Check the SQL server error log if you can see a message related to "256 misaligned reads", this may related to a konwn issue, check below workaround:

    1. Open regedit
    2. Locate Computer/HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\Services\stornvme\Parameters\Devices
    3. Create a new Muti-string value named "ForcedPhysicalSectorsSizeInBytes"
    4. Modify the value to *4095
    5. Close and restart machine, retry the installation

    Best regards,

    Molly

    ============================================

    If the Answer is helpful, please click "Accept Answer" and upvote it

    0 comments No comments