SQL Server install failure

Question

need SQL Server for my exam tomorrow but the installation keeps failing

I think it is an already existing instance of sql server but when i go to programs and delete sql server 2019, it says that the program is not found and if i want to delete it from my programs list

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2147467259
Start time: 2021-06-01 14:35:09
End time: 2021-06-01 14:36:23
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: DESKTOP-6VM4M36
Machine processor count: 12
OS version: Microsoft Windows 10 Pro (10.0.19042)
OS service pack:
OS region: United States
OS language: Nederlands (Nederland)
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 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Developer Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER MSAS15.MSSQLSERVER Analysis Services 1033 Developer Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER01 MSSQL15.MSSQLSERVER01 Database Engine Services 1033 Developer Edition 15.0.2000.5 No Yes
SQL Server 2019 MSSQLSERVER02 MSSQL15.MSSQLSERVER02 Database Engine Services 1033 Developer Edition 15.0.2000.5 No Yes
SQL Server 2019 Client Tools Connectivity 1033 15.0.2000.5 No Yes
SQL Server 2019 Client Tools Backwards Compatibility 1033 15.0.2000.5 No Yes
SQL Server 2019 Client Tools SDK 1033 15.0.2000.5 No Yes
SQL Server 2019 Data Quality Client 1033 Developer Edition 15.0.2000.5 No Yes
SQL Server 2019 Integration Services 1033 Developer Edition 15.0.2000.5 No Yes
SQL Server 2019 Master Data Services 1033 Developer 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: NT Service\SQLAgent$MSSQLSERVER03
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
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\20210601_143508\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FEATURES: SQLENGINE
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 (x86)\sqlserver
INSTANCEID: MSSQLSERVER03
INSTANCENAME: MSSQLSERVER03
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: Latin1_General_CI_AS
SQLJAVADIR: <empty>
SQLMAXDOP: 12
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT Service\MSSQL$MSSQLSERVER03
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: DESKTOP-6VM4M36\Stef
SQLTELSVCACCT: NT Service\SQLTELEMETRY$MSSQLSERVER03
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: false
UpdateSource: MU
USEMICROSOFTUPDATE: false
USESQLRECOMMENDEDMEMORYLIMITS: false
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210601_143508\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: The system cannot find the path specified
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.2000.5&EvtType=0xF57C3D6F%400xDC80C325&EvtType=0xF57C3D6F%400xDC80C325

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\20210601_143508\SystemConfigurationCheck_Report.htm

Answer 1

Firstly you should rerun the SQL uninstaller and ensure you have uninstalled all SQL components (instance and shared). Failure to do this can really mess up your machine.

It looks to me like you had a previous SQL installation installed. You might have partially uninstalled it (because SQL installs are actually 2 parts - instance specific and shared). It looks to me like you just deleted some of the installed components without uninstalling and now SQL cannot install because it wants to update/uninstall older stuff and it can't because they don't exist anymore. At this point your machine is messed up.

When uninstalling SQL you should always uninstall any per-instance components first such as a SQL2017 instance including the DB, SSIS, etc. Then if you don't want any SQL components you need to run the uninstall again and choose to uninstall the shared components (client connectivity, SMO, etc). You should never manually delete SQL folders or registry entries until you are sure all SQL components have been uninstalled.

After uninstalling everything you can (except for commonly shared things like SQL object types which are fine as is) try again. If it still fails the only remaining recourse is to manually go into registry and remove SQL registry entries to get it to the point where SQL can install again.

Answer 2

In the folder C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210601_143508\ there should be plenty of log files. One of them may tell us which file that is missing. Details.txt is probably the best one to start with.

These files are very verbose - and yet, it is not always possible to say for sure why Setup failed.

Answer 3

Hi @Stef Van der Straeten ,

Welcome to Microsoft Q&A!

You could follow below steps to delete the left components and then reinstall SQL Server:

1. Uninstall the existing SQL Server and all the components from the add remove program.
2. Backup the registry.
3. Delete the following keys using regedit:
   --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
   --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.
5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
6. Rename all the SQL Server folders in the computer.
7. Reboot the machine.

If there have any errors when you reinstall SQL Server, please provide more error details from Details.txt(%programfiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\YYYYMMDD_hhmmss)

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
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.

Answer 4

sorry but horrible idea to uninstall the SQL Server is any other option?? Because everything is blank.