Database engine failed SQL Server 2022

Question

Database engine failed to install. I have gone through all the solutions posted but nothing worked. find below my summary report:

Overall summary:

Final result: Failed: see details below

Exit code (Decimal): -2147467259

Start time: 2024-09-01 16:24:03

End time: 2024-09-01 16:28:22

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: LAPTOP-013F169E

Machine processor count: 12

OS version: Microsoft Windows 11 Home (10.0.26100)

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

SQL Server 2022 MSSQLSERVER MSAS16.MSSQLSERVER Analysis Services 1033 Developer Edition 16.0.1000.6 No Yes

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:

None discovered.

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

User Input Settings:

ACTION: Install

ADDCURRENTUSERASSQLADMIN: false

AGTSVCACCOUNT: NT Service\SQLAgent$DEVPRACTICE

AGTSVCPASSWORD: *****

AGTSVCSTARTUPTYPE: Manual

ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS16.DEVPRACTICE\OLAP\Backup

ASCOLLATION: Latin1_General_CI_AS

ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS16.DEVPRACTICE\OLAP\Config

ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS16.DEVPRACTICE\OLAP\Data

ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS16.DEVPRACTICE\OLAP\Log

ASPROVIDERMSOLAP: 1

ASSERVERMODE: MULTIDIMENSIONAL

ASSVCACCOUNT: NT Service\MSOLAP$DEVPRACTICE

ASSVCPASSWORD: <empty>

ASSVCSTARTUPTYPE: Automatic

ASSYSADMINACCOUNTS: LAPTOP-013F169E\nedu_

ASTELSVCACCT: NT Service\SSASTELEMETRY$DEVPRACTICE

ASTELSVCPASSWORD: <empty>

ASTELSVCSTARTUPTYPE: Automatic

ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS16.DEVPRACTICE\OLAP\Temp

AZUREARCPROXYSERVER:

AZUREBILLEDEDITION:

AZUREREGION:

AZURERESOURCEGROUP:

AZURESERVICEPRINCIPAL:

AZURESERVICEPRINCIPALSECRET: *****

AZURESUBSCRIPTIONID:

AZURETENANTID:

BROWSERSVCSTARTUPTYPE: Automatic

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

ENABLERANU: false

ENU: true

EXTSVCACCOUNT: <empty>

EXTSVCPASSWORD: <empty>

FEATURES: SQLENGINE, AS

FILESTREAMLEVEL: 0

FILESTREAMSHARENAME: <empty>

FTSVCACCOUNT: <empty>

FTSVCPASSWORD: <empty>

HELP: false

IACCEPTSQLSERVERLICENSETERMS: true

IACKNOWLEDGEENTCALLIMITS: false

INDICATEPROGRESS: false

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

INSTANCENAME: DEVPRACTICE

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

QUIETSIMPLE: false

ROLE:

SAPWD: *****

SECURITYMODE: SQL

SQLBACKUPDIR: <empty>

SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS

SQLMAXDOP: 6

SQLMAXMEMORY: 2147483647

SQLMINMEMORY: 0

SQLSVCACCOUNT: NT Service\MSSQL$DEVPRACTICE

SQLSVCINSTANTFILEINIT: false

SQLSVCPASSWORD: <empty>

SQLSVCSTARTUPTYPE: Automatic

SQLSYSADMINACCOUNTS: LAPTOP-013F169E\nedu_

SQLTELSVCACCT: NT Service\SQLTELEMETRY$DEVPRACTICE

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

UpdateSource: MU

USEMICROSOFTUPDATE: false

USESQLRECOMMENDEDMEMORYLIMITS: false

Configuration file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240901_162402\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: 0x80004005

Error description: Unknown error (0xe0000235)

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=0xF57C3D6F%400xDC80C325&EvtType=0xF57C3D6F%400xDC80C325

Feature: Analysis Services

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\20240901_162402\SystemConfigurationCheck_Report.htm

Answer 1

hi dear chinedu, The error message indicates that the installation of the SQL Server Database Engine Services feature failed with an unknown error (0xe0000235). To resolve this issue, follow these steps:

1. Review the SystemConfigurationCheck_Report.htm file for detailed information about the failure.
2. Check the Windows Event Viewer for any related errors or warnings.
3. Ensure that the Windows Firewall is configured to allow the necessary ports for SQL Server. See the link provided in the warning message for more information.
4. Run the SQL Server setup process again, selecting only the Database Engine Services feature.
5. If the issue persists, try uninstalling and then reinstalling the feature.
6. If you continue to experience issues, consider seeking assistance from a qualified SQL Server administrator or Microsoft support.

Additionally, consider the following general troubleshooting steps:

• Verify that the installation media is valid and not corrupted.
• Check for any pending Windows updates and install them before retrying the SQL Server installation.
• Ensure that the system meets the minimum requirements for SQL Server 2016 (version 16.0).
• Review the SQL Server setup logs for more detailed information about the failure.

Remember to carefully evaluate the error messages and warnings to ensure a successful installation.