Share via

How do I fix MSSQL Server 2022 Database Engine Services failing to install?

JC Sanders 5 Reputation points
2023-03-28T13:45:32.1966667+00:00

I have been struggling with this for far too long now. I've reinstalled it twice now with 9 repair tries. Still no luck. I need some help because my classes require it to be installed.

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068578302
  Start time:                    2023-03-28 15:28:31
  End time:                      2023-03-28 15:31:11
  Requested action:              Repair

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for DQ:              Use the following information to resolve the error, and then try the setup process again.
  Next step for SQLEngine:       Use the following information to resolve the error, and then try the setup process again.


Machine Properties:
  Machine name:                  H4Z3YS_WRKHORSE
  Machine processor count:       12
  OS version:                    Microsoft Windows 11 Home Single Language (10.0.22621)
  OS service pack:               
  OS region:                     United States
  OS language:                   English (United Kingdom)
  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      MSSQLSERVER1         MSSQL16.MSSQLSERVER1           Database Engine Services                 1033                 Developer Edition    16.0.1050.5     No         Yes       
  SQL Server 2022      MSSQLSERVER1         MSAS16.MSSQLSERVER1            Analysis Services                        1033                 Developer Edition    16.0.1050.5     No         Yes       
  SQL Server 2022      SQL_DATABASE         MSSQL16.SQL_DATABASE           Database Engine Services                 1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      SQL_DATABASE         MSSQL16.SQL_DATABASE           Data Quality Services                    1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      SQL_DATABASE         MSAS16.SQL_DATABASE            Analysis Services                        1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022      MSSQLSERVER          MSSQL16.MSSQLSERVER            Database Engine Services                 1033                 Developer Edition    16.0.1050.5     No         Yes       
  SQL Server 2022                                                          Data Quality Client                      1033                 Developer Edition    16.0.1000.6     No         Yes       
  SQL Server 2022                                                          Integration Services                     1033                 Developer Edition    16.0.1050.5     No         Yes       

Package properties:
  Description:                   Microsoft SQL Server 2022 
  ProductName:                   SQL Server 2022
  Type:                          RTM
  Version:                       16
  SPLevel:                       0
  Installation location:         C:\Users\ogdri\OneDrive\Desktop\02_Resources\Developer_ENU\x64\setup\
  Installation edition:          Developer

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

User Input Settings:
  ACTION:                        Repair
  AGTDOMAINGROUP:                <empty>
  AGTSVCACCOUNT:                 <empty>
  AGTSVCPASSWORD:                <empty>
  AGTSVCSTARTUPTYPE:             Manual
  ASCONFIGDIR:                   Config
  ASSVCACCOUNT:                  NT Service\MSOLAP$SQL_DATABASE
  ASSVCPASSWORD:                 <empty>
  ASTELSVCACCT:                  NT Service\SSASTELEMETRY$SQL_DATABASE
  ASTELSVCPASSWORD:              <empty>
  ASTELSVCSTARTUPTYPE:           Automatic
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230328_152831\ConfigurationFile.ini
  ENU:                           true
  EXTSVCACCOUNT:                 <empty>
  EXTSVCPASSWORD:                <empty>
  FAILOVERCLUSTERGROUP:          <empty>
  FAILOVERCLUSTERNETWORKNAME:    <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 <empty>
  HELP:                          false
  IACKNOWLEDGEENTCALLIMITS:      false
  INDICATEPROGRESS:              false
  INSTANCENAME:                  SQL_DATABASE
  ISMASTERSVCACCOUNT:            NT AUTHORITY\Network Service
  ISMASTERSVCPASSWORD:           <empty>
  ISMASTERSVCPORT:               8391
  ISMASTERSVCSSLCERTCN:          <empty>
  ISMASTERSVCSTARTUPTYPE:        Automatic
  ISMASTERSVCTHUMBPRINT:         <empty>
  ISSVCACCOUNT:                  NT Service\MsDtsServer160
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  ISTELSVCACCT:                  NT Service\SSISTELEMETRY160
  ISTELSVCPASSWORD:              <empty>
  ISTELSVCSTARTUPTYPE:           Automatic
  ISWORKERSVCACCOUNT:            NT AUTHORITY\Network Service
  ISWORKERSVCCERT:               <empty>
  ISWORKERSVCMASTER:             <empty>
  ISWORKERSVCPASSWORD:           <empty>
  ISWORKERSVCSTARTUPTYPE:        Automatic
  QUIET:                         false
  QUIETSIMPLE:                   false
  SQLSVCACCOUNT:                 NT Service\MSSQL$SQL_DATABASE
  SQLSVCPASSWORD:                <empty>
  SQLTELSVCACCT:                 NT Service\SQLTELEMETRY$SQL_DATABASE
  SQLTELSVCPASSWORD:             <empty>
  SQLTELSVCSTARTUPTYPE:          Automatic
  SUPPRESSPAIDEDITIONNOTICE:     false
  SUPPRESSPRIVACYSTATEMENTNOTICE: false
  UIMODE:                        Normal

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

Detailed results:
  Feature:                       Data Quality Services
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1050.5&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  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, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1050.5&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  Feature:                       Analysis Services
  Status:                        Passed

  Feature:                       SQL Browser
  Status:                        Passed

  Feature:                       SQL Writer
  Status:                        Passed

  Feature:                       Integration Services
  Status:                        Passed

  Feature:                       Data Quality Client
  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\20230328_152831\SystemConfigurationCheck_Report.htm
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,853 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 102.1K Reputation points MVP
    2023-03-28T21:08:46.86+00:00

    Repair is failing, because as it says, you cannot repair something that never installed successfully.

    Rather than trying a repair, try a new install and share the Summary file from that attempt. Depending on what that one says, we may ask fore more files.

    0 comments
  2. Seeya Xi-MSFT 16,451 Reputation points
    2023-03-29T02:53:21.0633333+00:00

    Hi @JC Sanders ,

    You can try to uninstall it cleanly and install it again.

    Please follow the below steps to remove all components of previous installed SQL Server completely:

    1. Remove all SQL Server components from 'Programs and Features'
    2. Backup the registry
    3. Delete the following keys in regedit:

    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

    --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

    1. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
    2. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
    3. Reboot the machine

    In addition, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

    You can check the installation conditions before installation by referring to the following link.

    https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16

    Best regards,

    Seeya

    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
  3. Alok Jha 0 Reputation points
    2024-05-04T05:46:58.98+00:00

    Fixed the issue follow this link :https://youtu.be/MsxC3U6YFgM?si=K-ZPXrwOqwJeFLFA

    0 comments