question

abdullahdoleh-8679 avatar image
0 Votes"
abdullahdoleh-8679 asked AmeliaGu-msft commented

Microsoft SQL Server 2019

im trying to install sql server on windows 10 and I have this error
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068052377
Start time: 2022-05-04 08:16:55
End time: 2022-05-04 08:18:49
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-B3M1SK0
Machine processor count: 4
OS version: Microsoft Windows 10 Home (10.0.19043)
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 2019 Master Data Services 1033 15.0.2000.5 No No

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\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
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\20220504_081634\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\MicrosoftSQLServer
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: 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: 4
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: DESKTOP-B3M1SK0\home
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 4
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\20220504_081634\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\150\Setup Bootstrap\Log\20220504_081634\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=15.0.4013.40&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=2094702 for information about ports to open for each feature.

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

sql-server-generalsql-server-reporting-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi abdullahdoleh-8679,

How are things going? Was the answer helpful?
Please feel free to let us know if you have any other question. If the post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered AmeliaGu-msft commented

Hi abdullahdoleh-8679,

Component error code: 1639
Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220504_081634\sql_engine_core_inst_Cpu64_1.log
Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.

Please check log file in C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220504_081634\sql_engine_core_inst_Cpu64_1.log to see if there are any detailed error message.
And this issue may be due to an incomplete MSI installation.
Please check the solution in this article which might be helpful:

msiexec /x {GUID}
In my case the GUID is in the error message i.e. {7E0C055D-520F-474C-A7ED-755405FBA017}
Here is the command I executed from the command prompt.
msiexec /x {7E0C055D-520F-474C-A7ED-755405FBA017}
As soon as I clicked Yes, it uninstalled the component. Then, I started to install again and it worked fine.


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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

the command said that this action is only valid on programs that are installed

0 Votes 0 ·
AmeliaGu-msft avatar image AmeliaGu-msft abdullahdoleh-8679 ·

Hi abdullahdoleh-8679,
Thanks for your reply.

Specified instance {A60B3D8E-5311-4BF1-AF7A-D1AC15F9152E} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.

It seems there is remnants of previous installation which has left orphaned entries in the windows installer registry. Please try to use msiexec /x {A60B3D8E-5311-4BF1-AF7A-D1AC15F9152E} remove it.
If it does not work, please try to use the steps from this article to remove previous failed installation.

Best Regards,
Amelia



0 Votes 0 ·
abdullahdoleh-8679 avatar image
0 Votes"
abdullahdoleh-8679 answered abdullahdoleh-8679 published

this the file that you asked for
=== Verbose logging started: 5/4/2022 8:18:17 Build type: SHIP UNICODE 5.00.10011.00 Calling process: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019\x64\ScenarioEngine.exe ===
MSI (c) (80:2C) [08:18:17:626]: Resetting cached policy values
MSI (c) (80:2C) [08:18:17:626]: Machine policy value 'Debug' is 0
MSI (c) (80:2C) [08:18:17:626]: RunEngine:
Product: C:\SQL2019\Developer_ENU\x64\setup\sql_engine_core_inst.msi
Action:
CommandLine:
MSI (c) (80:2C) [08:18:17:626]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (80:2C) [08:18:17:626]: Grabbed execution mutex.
MSI (c) (80:2C) [08:18:19:817]: Cloaking enabled.
MSI (c) (80:2C) [08:18:19:817]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (80:2C) [08:18:19:817]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (F0:B8) [08:18:19:876]: Running installation inside multi-package transaction C:\SQL2019\Developer_ENU\x64\setup\sql_engine_core_inst.msi
MSI (s) (F0:B8) [08:18:19:876]: Grabbed execution mutex.
MSI (s) (F0:88) [08:18:19:886]: Resetting cached policy values
MSI (s) (F0:88) [08:18:19:886]: Machine policy value 'Debug' is 0
MSI (s) (F0:88) [08:18:19:886]:
RunEngine:
Product: C:\SQL2019\Developer_ENU\x64\setup\sql_engine_core_inst.msi
Action:
CommandLine:
MSI (s) (F0:88) [08:18:19:886]: Machine policy value 'TransformsSecure' is 0
MSI (s) (F0:88) [08:18:19:886]: User policy value 'TransformsAtSource' is 0
MSI (s) (F0:88) [08:18:19:960]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (F0:88) [08:18:19:960]: Specified instance {A60B3D8E-5311-4BF1-AF7A-D1AC15F9152E} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (F0:88) [08:18:19:960]: MainEngineThread is returning 1639
MSI (s) (F0:B8) [08:18:19:960]: User policy value 'DisableRollback' is 0
MSI (s) (F0:B8) [08:18:19:960]: Machine policy value 'DisableRollback' is 0
MSI (s) (F0:B8) [08:18:19:960]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (F0:B8) [08:18:19:960]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (F0:B8) [08:18:19:960]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (F0:B8) [08:18:19:960]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (80:2C) [08:18:19:968]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (80:2C) [08:18:19:968]: MainEngineThread is returning 1639
=== Verbose logging stopped: 5/4/2022 8:18:19 ===

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.