Unable to install SQL Server (setup.exe) Exit code (decimal): -2068052404

Question

Unable to install SQL Server (setup.exe) Exit code (decimal): -2068052404

Olagunju Oladayo 66

on the first instance of my installation, i went for express instead of developer
then i uninstalled express and downloaded the SQL developer edition
However, at the very end of my installation, I keep having this error after many trials
Please, I need urgent help that will work

Thanks

Below is the summary of the error message in the log folder

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052404
Start time: 2022-01-19 13:13:14
End time: 2022-01-19 13:14:00
Requested action: Install

Machine Properties:
Machine name: DAZIPC
Machine processor count: 4
OS version: Microsoft Windows 10 Pro (10.0.18363)
OS service pack:
OS region: Nigeria
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 2019 SQLEXPRESS MSSQL15.SQLEXPRESS Database Engine Services 1033 Express Edition 15.0.2000.5 No Yes
SQL Server 2019 SQLEXPRESS MSSQL15.SQLEXPRESS SQL Server Replication 1033 Express Edition 15.0.2000.5 No Yes
SQL Server 2019 SQLEXPRESS01 MSSQL15.SQLEXPRESS01 Database Engine Services 1033 Express Edition 15.0.2000.5 No Yes

Package properties:
Description: Microsoft SQL Server 2019
ProductName: SQL Server 2019
Type: RTM
Version: 15
SPLevel: 0
Installation location: C:\SQL2019\Developer_ENU\x64\setup\
Installation edition: Developer

Product Update Status:
User selected not to include product updates.

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: <empty>
AGTSVCPASSWORD: <empty>
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
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME: <empty>
CLTRESULTDIR: <empty>
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CLTWORKINGDIR: <empty>
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220119_131311\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FEATURES:
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
IACCEPTSQLSERVERLICENSETERMS: true
IACKNOWLEDGEENTCALLIMITS: false
INDICATEPROGRESS: true
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: <empty>
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
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: <empty>
PBDMSSVCPASSWORD: <empty>
PBDMSSVCSTARTUPTYPE: 0
PBENGSVCACCOUNT: <empty>
PBENGSVCPASSWORD: <empty>
PBENGSVCSTARTUPTYPE: 0
PBPORTRANGE: <empty>
PBSCALEOUT: false
PID: *****
QUIET: true
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLJAVADIR: <empty>
SQLMAXDOP: 0
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: <empty>
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: DAZIPC\USER
SQLTELSVCACCT: <empty>
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: 0
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 0
SQLTEMPDBFILEGROWTH: -1
SQLTEMPDBFILESIZE: -1
SQLTEMPDBLOGDIR: <empty>
SQLTEMPDBLOGFILEGROWTH: -1
SQLTEMPDBLOGFILESIZE: -1
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 0
UIMODE: Normal
UpdateEnabled: false
UpdateSource: MU
USEMICROSOFTUPDATE: false
USESQLRECOMMENDEDMEMORYLIMITS: true
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220119_131311\ConfigurationFile.ini

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=2094702 for information about ports to open for each feature.

Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220119_131311\SystemConfigurationCheck_Report.htm

Accepted answer

6 additional answers

Your answer

Answer 1

Erland Sommarskog 121.8K MVP Volunteer Moderator

So did you check that you have that file on the disk?

The message about network device is funny. C:\ does not sound like a network device to me.

I don't think this is due to your previous installation and uninstallation was faulty. But it could be that the download was damaged. I would try downloading again, possibly through a different channel on a different computer.

And, hm, check the quaratine folder for your AntiVirus...

Answer 2

Hi @Olagunju Oladayo ,

Here I will add that SQL Server is Microsoft's relational database management system (RDBMS), which is a full-featured database. SQL Server Management Studio (SSMS) is the primary interface tool for SQL Server. They do not affect each other's installation. You can install SQL Server successfully first, and then install this tool, otherwise it is meaningless to install SSMS successfully.
You have post too little useful information here, could you post a more detailed detail.txt like Erland mentioned?

then i uninstalled express and downloaded the SQL developer edition

I see that you have uninstalled express edition and you are installing developer edition, you need to uninstall express edition cleanly to avoid errors during installation of developer edition.
Please follow the below steps to remove all components of previous installed SQL Server completely:

Remove all SQL Server components from 'Programs and Features'
Backup the registry
Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server
Reboot the machine
In addition, please use an administrator account to reinstall SQL Server on your computer(Right click->run as administrator).

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".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Olagunju Oladayo 66 Reputation points

2022-01-20T06:27:45.407+00:00

Thanks for the assistance so far, I really appreciate

@Seeya Xi-MSFT , I have two folders here which as he @Erland Sommarskog earlier suggested shows my installation attempts

The most recent installation has this detail text document 166555-detail.txt

The initial installation however has this detail text document 166656-detail-rules.txt

Also, I believe I uninstalled all the components of the edition version. But is there an application that you can suggest that can help do that once and for all
You mentioned the fact of backing up my registry, please how do I do that?
lastly, I also downloaded the SQL developer application in an ISO format, I know how to extract the files but how do I install it manually?

Thanks
Seeya Xi-MSFT 16,586 Reputation points

2022-01-20T07:19:28.337+00:00

Hi @Olagunju Oladayo ,

Please see this blog about Backup the registry: https://support.microsoft.com/en-us/topic/how-to-back-up-and-restore-the-registry-in-windows-855140ad-e318-2a13-2829-d428a2ab0692
and this article for installation: https://www.sqlshack.com/how-to-install-sql-server-developer-edition/
Note: Some choices in the installation process are just for reference, you should refer to the steps.

Best regards,
Seeya

Answer 3

Olaf Helper 47,441

Warning IsFirewallEnabled The Windows Firewall is enabled

I don't see any error message, only a warning, which you can ignore.
Succeeded the installation? Do you see SQL Server Database Engin in Windows services and is it running?

Olagunju Oladayo 66 Reputation points

2022-01-19T19:23:39.273+00:00

I'm not actually clear on your response because the installer didn't tell me the installation was successful so please help me understand better

And are you also saying that I should go ahead to install Microsoft SQL Server Management Studio 18 and everything will work fine?

Then what am I getting wrong with the widows Firewall? What do you suggest I do?

Thanks

Answer 4

Erland Sommarskog 121.8K MVP Volunteer Moderator

SQL Server Management Studio is an independent install from SQL Server, you can install it, no matter if SQL Server installed correctly or not.

Once you have installed SSMS, you will notice if SQL Server is running properly or not.

The summary file above is for Express Edition, but you say that you uninstalled Express in favour of Developer Edition. Maybe you should look at that log file instead? You find the log files in C:\Program Files\Microsoft SQL Server\Setup Bootstrap\150\Log where there is one folder per installation attempt.

A useful is detail.txt. It is very verbose, but this typically where you find why an installation failed.

Once you have everything working, don't forget to download and install the most recent Cumulative Update, CU14, to get bug fixes and improvements!

Olagunju Oladayo 66 Reputation points

2022-01-20T06:18:44.597+00:00

Thanks for the assistance so far, I really appreciate

@Seeya Xi-MSFT , I have two folders here which as he @Erland Sommarskog earlier suggested shows my installation attempts
the most recent installation has this detail text document

166580-detail.txt

The initial installation however has this detail text document 166637-detail-rules.txt

Also, I believe I uninstalled all the components of the edition version. But is there an application that you can suggest that can help do that once and for all
You mentioned the fact of backing up my registry, please how do I do that?
lastly, I alos downloaded the SQL developer application in an ISO format, I know how to extract the files but how do I install it manually?

Thanks

Answer 5

Olagunju Oladayo 66

Alright. I appreciate this

I will go through the blogs

However, you didn't mention what I got wrong from the detail.txt documents I shared earlier though

Thank you

Share via

Unable to install SQL Server (setup.exe) Exit code (decimal): -2068052404

6 additional answers

Your answer