When installing SQL Server 2017 on my computer/server I am receiving an installation error.
Error Log
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052377
Start time: 2018-08-13 13:34:16
End time: 2018-08-13 13:37:03
Requested action: Install
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 FullText: Use the following information to resolve the error, and then try the setup process again.
Next step for sql_inst_mpy: Use the following information to resolve the error, and then try the setup process again.
Next step for sql_inst_mr: Use the following information to resolve the error, and then try the setup process again.
Next step for AdvancedAnalytics: 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.
Next step for Replication: Use the following information to resolve the error, and then try the setup process again.
Next step for AS: Use the following information to resolve the error, and then try the setup process again.
Machine Properties:
Machine name: DESKTOP-KJGHCSV
Machine processor count: 8
OS version: Microsoft Windows 10 Pro (10.0.17134)
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 2017 Client Tools Connectivity 1033 14.0.1000.169 No Yes
SQL Server 2017 Client Tools Backwards Compatibility 1033 14.0.1000.169 No Yes
SQL Server 2017 Client Tools SDK 1033 14.0.1000.169 No Yes
SQL Server 2017 Data Quality Client 1033 Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 Integration Services 1033 Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 Scale Out Master 1033 Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 Scale Out Worker 1033 Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 Master Data Services 1033 Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 Machine Learning Server (Standalone) Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 R Developer Edition 14.0.1000.169 No Yes
SQL Server 2017 Python Developer Edition 14.0.1000.169 No Yes
Package properties:
Description: Microsoft SQL Server 2017
ProductName: SQL Server 2017
Type: RTM
Version: 14
SPLevel: 0
Installation location: C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\
Installation edition: Developer
Product Update Status:
None discovered.
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: NT Service\SQLSERVERAGENT
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Config
ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Data
ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: TABULAR
ASSVCACCOUNT: NT Service\MSSQLServerOLAPService
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: RADISE\HBopuri
ASTELSVCACCT: NT Service\SSASTELEMETRY
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: Automatic
ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS14.MSSQLSERVER\OLAP\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\140\Setup Bootstrap\Log\20180813_133416\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: NT Service\MSSQLLaunchpad
EXTSVCPASSWORD: <empty>
FEATURES: SQLENGINE, REPLICATION, ADVANCEDANALYTICS, SQL_INST_MR, SQL_INST_MPY, FULLTEXT, DQ, AS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT Service\MSSQLFDLauncher
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTPYTHONLICENSETERMS: true
IACCEPTROPENLICENSETERMS: true
IACCEPTSQLSERVERLICENSETERMS: true
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
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: false
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: *****
SECURITYMODE: SQL
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: RADISE\HBopuri
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>
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 0
UIMODE: Normal
UpdateEnabled: true
UpdateSource: MU
USEMICROSOFTUPDATE: false
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\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: 1639
Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
Feature: Full-Text and Semantic Extractions for Search
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: 1639
Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
Feature: Python
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: 1639
Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
Feature: R
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: 1639
Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
Feature: Machine Learning Services (In-Database)
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: 1639
Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
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\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
Feature: SQL Server Replication
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\140\Setup Bootstrap\Log\20180813_133416\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=14.0.1000.169&EvtType=sql_engine_core_inst.msi%400x162A16FE%400x1639
Feature: Analysis 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 Analysis Services
Component error code: 1639
Component log file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_as_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=14.0.1000.169&EvtType=sql_as.msi%400x162A16FE%400x1639
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\SystemConfigurationCheck_Report.htm
Core Components Log File
C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20180813_133416\sql_engine_core_inst_Cpu64_1.log
=== Verbose logging started: 08/13/2018 13:36:57 Build type: SHIP UNICODE 5.00.10011.00 Calling process: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\SQL2017\x64\ScenarioEngine.exe ===
MSI (c) (8C:28) [13:36:57:364]: Resetting cached policy values
MSI (c) (8C:28) [13:36:57:364]: Machine policy value 'Debug' is 0
MSI (c) (8C:28) [13:36:57:364]: ******* RunEngine:
******* Product: C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\sql_engine_core_inst.msi
******* Action:
******* CommandLine: **********
MSI (c) (8C:28) [13:36:57:364]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (8C:28) [13:36:57:364]: Grabbed execution mutex.
MSI (c) (8C:28) [13:36:57:365]: Cloaking enabled.
MSI (c) (8C:28) [13:36:57:365]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (8C:28) [13:36:57:365]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (7C:E8) [13:36:57:367]: Running installation inside multi-package transaction C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\sql_engine_core_inst.msi
MSI (s) (7C:E8) [13:36:57:367]: Grabbed execution mutex.
MSI (s) (7C:AC) [13:36:57:368]: Resetting cached policy values
MSI (s) (7C:AC) [13:36:57:368]: Machine policy value 'Debug' is 0
MSI (s) (7C:AC) [13:36:57:368]: ******* RunEngine:
******* Product: C:\Users\HBopuri\Downloads\en_sql_server_2017_developer_x64_dvd_11296168\x64\setup\sql_engine_core_inst.msi
******* Action:
******* CommandLine: **********
MSI (s) (7C:AC) [13:36:57:368]: Machine policy value 'TransformsSecure' is 0
MSI (s) (7C:AC) [13:36:57:368]: User policy value 'TransformsAtSource' is 0
MSI (s) (7C:AC) [13:36:57:368]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (7C:AC) [13:36:57:368]: Specified instance {DED314CA-0EFE-4593-9D66-EF75E5289A4C} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (7C:AC) [13:36:57:369]: MainEngineThread is returning 1639
MSI (s) (7C:E8) [13:36:57:369]: User policy value 'DisableRollback' is 0
MSI (s) (7C:E8) [13:36:57:369]: Machine policy value 'DisableRollback' is 0
MSI (s) (7C:E8) [13:36:57:369]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (7C:E8) [13:36:57:370]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (7C:E8) [13:36:57:370]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (7C:E8) [13:36:57:370]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:28) [13:36:57:371]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:28) [13:36:57:371]: MainEngineThread is returning 1639
=== Verbose logging stopped: 08/13/2018 13:36:57 ===
I have tried completely uninstalling SQL Server and then reinstalling, but I am still receiving an error message and the installation fails.
Best Answer
The reason it failed is because of below.
This means in the windows installer registry there is remnants of previous installation which has left orphaned entries there. You have to manually remove it or use some tool.
This Blog talks about similar issue and used MS tool to cleanup registry. The link in the blog is dead this is Free windows installer cleanup utility which you can use for cleanup.
PS: Please backup the complete registry before you perform any cleanup. I am not sure how this cleanup utility works so you have to do on your own risk