Share via

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

Nelson Nwachia 51 Reputation points
2022-11-23T00:01:59.227+00:00

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

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,770 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chinedu Okechukwu 0 Reputation points
    2024-09-01T23:32:37.1166667+00:00

    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

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