how to solve this problem? I want to download SQL server.

ساره هانى فريد عبده بدوى 0 Reputation points
2024-04-25T11:06:08.61+00:00

Screenshot 2024-04-25 124804

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,221 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rahul Randive 8,521 Reputation points Microsoft Employee
    2024-04-25T14:25:51.65+00:00

    Hi @ساره هانى فريد عبده بدوى

    When encountering the following error during SQL Server installation, it is important to check the error log to obtain the specific and informative error message.

    To identify the cause of the issue, you can refer to the SQL Server error log located at C:\Program Files\Microsoft SQL Server<>\MSSQL\ERRORLOG (assuming a default installation). This log file contains important details about the startup process and any errors encountered during installation.

    In the file where you found the summary file, there is a file detail.txt, which is likely to give information about the error. Feel free to attach it here.

    If you find an error message about 256 misaligned reads, this is a known issue and below article suggests workarounds.

    Error- There have been 256 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS07\MSSQL\Template Data\master.mdf.

    https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size

    Thank you!

    0 comments
  2. GeethaThatipatri-MSFT 27,642 Reputation points Microsoft Employee
    2024-04-25T16:02:52.8666667+00:00

    @ساره هانى فريد عبده بدوى Adding to what @Rahul Randive mentioned This looks like a Script Upgrade failure. You will need to check the Error Log and if you see Error 912 and 3417 , you will need to check the Error entry before these codes to determine the issue. This article Troubleshoot upgrade script failures when applying an update - SQL Server | Microsoft Learn shows some common script upgrade failure causes depending on the error code. 

    Regards

    Geetha

    0 comments
  3. Molly Lu 761 Reputation points Microsoft Vendor
    2024-04-26T02:13:27.8433333+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