I cant install SQL Server

T Roopram (21955509) 0 Reputation points
2024-03-25T18:59:22.82+00:00

Screenshot (1)

Can someone tell me how i can fix this, its been giving me this issue for so long i even tried to reset me pc?

Here is the log file:
Overall summary:

Final result: Failed: see details below

Exit code (Decimal): -2061893606

Start time: 2024-03-25 20:32:29

End time: 2024-03-25 20:34:49

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: TY-PC

Machine processor count: 16

OS version: Microsoft Windows 11 Home Single Language (10.0.22631)

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\Express_ENU\x64\setup\

Installation edition: Express

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: true

AGTSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE

AGTSVCPASSWORD: *****

AGTSVCSTARTUPTYPE: Disabled

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\20240325_203229\ConfigurationFile.ini

ENABLERANU: true

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: SQLEXPRESS

INSTANCENAME: SQLEXPRESS

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: AllFeatures_WithDefaults

SAPWD: <empty>

SECURITYMODE: <empty>

SQLBACKUPDIR: <empty>

SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

SQLMAXDOP: 0

SQLMAXMEMORY: 2147483647

SQLMINMEMORY: 0

SQLSVCACCOUNT: NT Service\MSSQL$SQLEXPRESS

SQLSVCINSTANTFILEINIT: true

SQLSVCPASSWORD: <empty>

SQLSVCSTARTUPTYPE: Automatic

SQLSYSADMINACCOUNTS: TY-PC\tyron

SQLTELSVCACCT: NT Service\SQLTELEMETRY$SQLEXPRESS

SQLTELSVCPASSWORD: <empty>

SQLTELSVCSTARTUPTYPE: Automatic

SQLTEMPDBDIR: <empty>

SQLTEMPDBFILECOUNT: 1

SQLTEMPDBFILEGROWTH: 64

SQLTEMPDBFILESIZE: 8

SQLTEMPDBLOGDIR: <empty>

SQLTEMPDBLOGFILEGROWTH: 64

SQLTEMPDBLOGFILESIZE: 8

SQLUSERDBDIR: <empty>

SQLUSERDBLOGDIR: <empty>

SUPPRESSPAIDEDITIONNOTICE: false

SUPPRESSPRIVACYSTATEMENTNOTICE: false

TCPENABLED: 0

UIMODE: AutoAdvance

UpdateEnabled: false

UpdateSource: MU

USEMICROSOFTUPDATE: false

USESQLRECOMMENDEDMEMORYLIMITS: false

Configuration file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240325_203229\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:

Global rules:

Warning IsFirewallEnabled The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at https://go.microsoft.com/fwlink/?linkid=2162127 for information about ports to open for each feature.

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

My pc is a HP Victus 16 Laptop
CPU specs: AMD Ryzen 7 6800H with Radeon Graphics 3.20 GHz
16gb ddr5
system type: 64-bit operating system, x64-based processor
and Windows 11 Home Single Language

Thank You

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

3 answers

Sort by: Most helpful
  1. Olaf Helper 44,501 Reputation points
    2024-03-25T19:06:58.8033333+00:00

    Do what the error message says: View and Read SQL Server Setup Log Files for more details


  2. LiHongMSFT-4306 27,016 Reputation points
    2024-03-26T01:48:43.2233333+00:00

    Hi @T Roopram (21955509)

    Please check the Detail.txt file for more information.

    If found error like this: There have been 256 misaligned log IOs which required falling back to synchronous IO, it comes to a known issue when install SQL Server 2022 on Windows 11 and Windows Server 2022.

    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".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  3. T Roopram (21955509) 0 Reputation points
    2024-03-26T10:22:35.7466667+00:00

    Hi Thank you guys for the suggestions. I downgraded my windows from 11 to 10 using a bootable USB and SQL has installed successfully and everything is working fine I'm still not sure what the issue was but I think is has something to do with the windows 11 home version that my laptop had.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.