Database Engine Services Failed

Question

Database Engine Services Failed

Marwan Ashraf 0

I'm having a problem installing Microsoft SQL Server 2022. my problem is database engine fails and don't want to succeed

User's image

That's the LOG file:

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068052377
  Start time:                    2023-06-16 22:11:26
  End time:                      2023-06-16 22:13:27
  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, and then try the setup process again.


Machine Properties:
  Machine name:                  DESKTOP-2JLIB85
  Machine processor count:       8
  OS version:                    Microsoft Windows 10 Pro (10.0.19045)
  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:         E:\SQLSERVER22\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\SQLSERVERAGENT
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  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:           
  AZUREBILLEDEDITION:            
  AZUREREGION:                   
  AZURERESOURCEGROUP:            
  AZURESERVICEPRINCIPAL:         
  AZURESERVICEPRINCIPALSECRET:   *****
  AZURESUBSCRIPTIONID:           
  AZURETENANTID:                 
  BROWSERSVCSTARTUPTYPE:         Disabled
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230616_221126\ConfigurationFile.ini
  ENABLERANU:                    false
  ENU:                           true
  EXTSVCACCOUNT:                 <empty>
  EXTSVCPASSWORD:                <empty>
  FEATURES:                      SQLENGINE
  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:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  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:                         <empty>
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  Arabic_CI_AS
  SQLMAXDOP:                     8
  SQLMAXMEMORY:                  2147483647
  SQLMINMEMORY:                  0
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCINSTANTFILEINIT:         false
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           DESKTOP-2JLIB85\Marwan
  SQLTELSVCACCT:                 NT Service\SQLTELEMETRY
  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\20230616_221126\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, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          1639
  Component log file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230616_221126\sql_engine_core_inst_Cpu64_1.log
  Error description:             Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
  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=sql_engine_core_inst.msi%400x162A16FE%400x1639

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\20230616_221126\SystemConfigurationCheck_Report.htm

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-06-17T08:39:10.64+00:00

It may be worth looking into C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230616_221126\sql_engine_core_inst_Cpu64_1.log. detail.txt in the same folder can also be useful.

These files are very verbose. Feel free to attach them here.
Marwan Ashraf 0 Reputation points

2023-06-17T10:25:59.8933333+00:00

is the Firewall causing the problem ?

Marwan Ashraf 0

@Erland Sommarskog

=== Verbose logging started: 6/16/2023  22:13:23  Build type: SHIP UNICODE 5.00.10011.00  Calling process: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\SQL2022\x64\ScenarioEngine.exe ===
MSI (c) (B0:F0) [22:13:23:213]: Resetting cached policy values
MSI (c) (B0:F0) [22:13:23:213]: Machine policy value 'Debug' is 0
MSI (c) (B0:F0) [22:13:23:213]: ******* RunEngine:
           ******* Product: E:\SQLSERVER22\Developer_ENU\x64\setup\sql_engine_core_inst.msi
           ******* Action: 
           ******* CommandLine: **********
MSI (c) (B0:F0) [22:13:23:214]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (B0:F0) [22:13:23:214]: Grabbed execution mutex.
MSI (c) (B0:F0) [22:13:23:303]: Cloaking enabled.
MSI (c) (B0:F0) [22:13:23:303]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (B0:F0) [22:13:23:307]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (9C:1C) [22:13:23:321]: Running installation inside multi-package transaction E:\SQLSERVER22\Developer_ENU\x64\setup\sql_engine_core_inst.msi
MSI (s) (9C:1C) [22:13:23:321]: Grabbed execution mutex.
MSI (s) (9C:B8) [22:13:23:324]: Resetting cached policy values
MSI (s) (9C:B8) [22:13:23:324]: Machine policy value 'Debug' is 0
MSI (s) (9C:B8) [22:13:23:324]: ******* RunEngine:
           ******* Product: E:\SQLSERVER22\Developer_ENU\x64\setup\sql_engine_core_inst.msi
           ******* Action: 
           ******* CommandLine: **********
MSI (s) (9C:B8) [22:13:23:326]: Machine policy value 'TransformsSecure' is 0
MSI (s) (9C:B8) [22:13:23:326]: User policy value 'TransformsAtSource' is 0
MSI (s) (9C:B8) [22:13:23:326]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (9C:B8) [22:13:23:326]: Specified instance {6621C765-569C-4D46-A8E9-C69A47971357} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (9C:B8) [22:13:23:326]: MainEngineThread is returning 1639
MSI (s) (9C:1C) [22:13:23:327]: User policy value 'DisableRollback' is 0
MSI (s) (9C:1C) [22:13:23:328]: Machine policy value 'DisableRollback' is 0
MSI (s) (9C:1C) [22:13:23:328]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (9C:1C) [22:13:23:328]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
MSI (s) (9C:1C) [22:13:23:328]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 
MSI (s) (9C:1C) [22:13:23:329]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (B0:F0) [22:13:23:330]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (B0:F0) [22:13:23:331]: MainEngineThread is returning 1639
=== Verbose logging stopped: 6/16/2023  22:13:23 ===

1 answer

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2023-06-17T08:39:10.64+00:00

It may be worth looking into C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230616_221126\sql_engine_core_inst_Cpu64_1.log. detail.txt in the same folder can also be useful.

These files are very verbose. Feel free to attach them here.
Marwan Ashraf 0 Reputation points

2023-06-17T10:25:59.8933333+00:00

is the Firewall causing the problem ?

Answer 1

OK FINALLY I FIXED THE ISSUE LET'S SEE HOW

First you need to delete everything related to MSSQL Server but you can't delete anything because of an error

here is the solution for this situation

Download Ashampoo Uninstaller https://www.ashampoo.com/en-nz/uninstaller from here it will give you 10 days free trial and if you add your email it will give you 30 days, then select Microsoft SQL Setup and click to delete it you will see the normal uninstallation after it finish it will delete the registry and everything else related to sql but you need to do this with the other setups and that's what happened when i tried to setup MSSQL after i did this

User's image

Share via

Database Engine Services Failed

1 answer

Your answer