Error Fix (Database engine service failed in sql server 2022 and 2019)

Question

Hello

i am having troubles installing sql server 2022. my error is sql database engine fails to starts

steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried installing sql 2019 on my laptop it did not work error was database engine fails to start, i formatted my laptop to install 2022 to see if it will work still the same error

has anyone experienced this error and how did they fix it

Answer 1

I am also having this issue. I have tried all of the above and nothing worked. Please find the error log i got:

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