Unable to install Microsoft SQL server 2022

Mohamed El Sayed Mohamed 20 Reputation points
2024-04-29T22:50:10.5966667+00:00

Hi,

Recently, I was trying to install Microsoft SQL Server, but the installation stops and this problem appeared
WhatsApp Image 2024-04-30 at 00.36.14_05440ff9

I found a summery.txt file in this direction [C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log] and that's what was on it:
Overall summary:

Final result: Failed: see details below

Exit code (Decimal): -2061893606

Start time: 2024-04-30 00:02:59

End time: 2024-04-30 00:04:30

Requested action: Install

Setup completed with required actions for features.

Troubleshooting information for those features:

Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

Machine Properties:

Machine name: CRINGYSAYED

Machine processor count: 16

OS version: Microsoft Windows 11 Pro (10.0.22635)

OS service pack:

OS region: United States

OS language: English (United States)

OS architecture: x64

Process architecture: 64 Bit

OS clustered: No

Product features discovered:

Product Instance Instance ID Feature Language Edition Version Clustered Configured

Package properties:

Description: Microsoft SQL Server 2022

ProductName: SQL Server 2022

Type: RTM

Version: 16

SPLevel: 0

Installation location: C:\SQL2022\Developer_ENU\x64\setup\

Installation edition: Developer

Product Update Status:

User selected not to include product updates.

Notice: Please read Microsoft SQL Server Software License Terms at aka.ms/useterms.

User Input Settings:

ACTION: Install

ADDCURRENTUSERASSQLADMIN: false

AGTSVCACCOUNT: NT Service\SQLSERVERAGENT

AGTSVCPASSWORD: *****

AGTSVCSTARTUPTYPE: Manual

ASBACKUPDIR: Backup

ASCOLLATION: Latin1_General_CI_AS

ASCONFIGDIR: Config

ASDATADIR: Data

ASLOGDIR: Log

ASPROVIDERMSOLAP: 1

ASSERVERMODE: TABULAR

ASSVCACCOUNT: <empty>

ASSVCPASSWORD: <empty>

ASSVCSTARTUPTYPE: Automatic

ASSYSADMINACCOUNTS: <empty>

ASTELSVCACCT: <empty>

ASTELSVCPASSWORD: <empty>

ASTELSVCSTARTUPTYPE: 0

ASTEMPDIR: Temp

AZUREARCPROXYSERVER: <empty>

AZUREBILLEDEDITION:

AZUREREGION: <empty>

AZURERESOURCEGROUP: <empty>

AZURESERVICEPRINCIPAL: <empty>

AZURESERVICEPRINCIPALSECRET: <empty>

AZURESUBSCRIPTIONID: <empty>

AZURETENANTID: <empty>

BROWSERSVCSTARTUPTYPE: Disabled

CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240430_000259\ConfigurationFile.ini

ENABLERANU: false

ENU: true

EXTSVCACCOUNT: <empty>

EXTSVCPASSWORD: <empty>

FEATURES: SQLENGINE

FILESTREAMLEVEL: 0

FILESTREAMSHARENAME: <empty>

FTSVCACCOUNT: <empty>

FTSVCPASSWORD: <empty>

HELP: false

IACCEPTSQLSERVERLICENSETERMS: true

IACKNOWLEDGEENTCALLIMITS: false

INDICATEPROGRESS: true

INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\

INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\

INSTALLSQLDATADIR: <empty>

INSTANCEDIR: C:\Program Files\Microsoft SQL Server

INSTANCEID: MSSQLSERVER

INSTANCENAME: MSSQLSERVER

ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service

ISMASTERSVCPASSWORD: <empty>

ISMASTERSVCPORT: 8391

ISMASTERSVCSSLCERTCN: <empty>

ISMASTERSVCSTARTUPTYPE: Automatic

ISMASTERSVCTHUMBPRINT: <empty>

ISSVCACCOUNT: NT AUTHORITY\Network Service

ISSVCPASSWORD: <empty>

ISSVCSTARTUPTYPE: Automatic

ISTELSVCACCT: <empty>

ISTELSVCPASSWORD: <empty>

ISTELSVCSTARTUPTYPE: 0

ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service

ISWORKERSVCCERT: <empty>

ISWORKERSVCMASTER: <empty>

ISWORKERSVCPASSWORD: <empty>

ISWORKERSVCSTARTUPTYPE: Automatic

NPENABLED: 0

PBDMSSVCACCOUNT: <empty>

PBDMSSVCPASSWORD: <empty>

PBDMSSVCSTARTUPTYPE: 0

PBENGSVCACCOUNT: <empty>

PBENGSVCPASSWORD: <empty>

PBENGSVCSTARTUPTYPE: 0

PBPORTRANGE: <empty>

PID: *****

PRODUCTCOVEREDBYSA: false

QUIET: true

QUIETSIMPLE: false

ROLE:

SAPWD: <empty>

SECURITYMODE: <empty>

SQLBACKUPDIR: <empty>

SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

SQLMAXDOP: 8

SQLMAXMEMORY: 2147483647

SQLMINMEMORY: 0

SQLSVCACCOUNT: NT Service\MSSQLSERVER

SQLSVCINSTANTFILEINIT: true

SQLSVCPASSWORD: <empty>

SQLSVCSTARTUPTYPE: Automatic

SQLSYSADMINACCOUNTS: CRINGYSAYED\LENOVO

SQLTELSVCACCT: NT Service\SQLTELEMETRY

SQLTELSVCPASSWORD: <empty>

SQLTELSVCSTARTUPTYPE: Automatic

SQLTEMPDBDIR: <empty>

SQLTEMPDBFILECOUNT: 8

SQLTEMPDBFILEGROWTH: 64

SQLTEMPDBFILESIZE: 8

SQLTEMPDBLOGDIR: <empty>

SQLTEMPDBLOGFILEGROWTH: 64

SQLTEMPDBLOGFILESIZE: 8

SQLUSERDBDIR: <empty>

SQLUSERDBLOGDIR: <empty>

SUPPRESSPAIDEDITIONNOTICE: false

SUPPRESSPRIVACYSTATEMENTNOTICE: false

TCPENABLED: 0

UIMODE: Normal

UpdateEnabled: false

UpdateSource: MU

USEMICROSOFTUPDATE: false

USESQLRECOMMENDEDMEMORYLIMITS: false

Configuration file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240430_000259\ConfigurationFile.ini

Detailed results:

Feature: Database Engine Services

Status: Failed

Reason for failure: An error occurred during the setup process of the feature.

Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.

Component name: SQL Server Database Engine Services Instance Features

Component error code: 0x851A001A

Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

Feature: SQL Browser

Status: Passed

Feature: SQL Writer

Status: Passed

Feature: Setup Support Files

Status: Passed

Rules with failures or warnings:

Rules report file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240430_000259\SystemConfigurationCheck_Report.htm

it's like today tell now and I can't solve this problem

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,869 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 102.2K Reputation points
    2024-04-30T21:34:02.6333333+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.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. CosmogHong-MSFT 23,561 Reputation points Microsoft Vendor
    2024-04-30T01:35:04.2333333+00:00

    Hi @Mohamed El Sayed Mohamed

    You may also check the detail.txt file for more details.

    View and Read SQL Server Setup Log Files - SQL Server | Microsoft Learn

    Considering the OS is Windows 11, please also check if exists system disk sector size greater than 4 KB.

    See this doc: Troubleshoot errors related to system disk sector size greater than 4 KB.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments