SQL error 1639

Question

I am installing SQL2019 express on my win 10 64bit but keep getting "error code 1639".
Anyone an idea how to solve this?
I have already reregistered windows installer but without success.
I also read somewhere to set windows installer to automatic but this doesn't work, I can't change the option.

Overall summary:

Final result: Failed: see details below
Exit code (Decimal): -2068052377
Start time: 2021-12-11 09:54:12
End time: 2021-12-11 09:54:34
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: WINKEL
Machine processor count: 16
OS version: Microsoft Windows 10 Pro (10.0.19042)
OS service pack:
OS region: België
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

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

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

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: true
AGTSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Disabled
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\20211211_095404\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: true
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\Microsoft_SQL_Server
INSTANCEID: SQLEXPRESS
INSTANCENAME: SQLEXPRESS
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: AllFeatures_WithDefaults
RSINSTALLMODE: DefaultNativeMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Latin1_General_CI_AS
SQLJAVADIR: <empty>
SQLMAXDOP: 0
SQLMAXMEMORY: 2147483647
SQLMINMEMORY: 0
SQLSVCACCOUNT: NT Service\MSSQL$SQLEXPRESS
SQLSVCINSTANTFILEINIT: true
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: WINKEL\Kim
SQLTELSVCACCT: NT Service\SQLTELEMETRY$SQLEXPRESS
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 1
SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8
SQLTEMPDBLOGDIR: <empty>
SQLTEMPDBLOGFILEGROWTH: 64
SQLTEMPDBLOGFILESIZE: 8
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SUPPRESSPAIDEDITIONNOTICE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 0
UIMODE: AutoAdvance
UpdateEnabled: false
UpdateSource: MU
USEMICROSOFTUPDATE: false
USESQLRECOMMENDEDMEMORYLIMITS: false
X86: false

Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20211211_095404\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\20211211_095404\sql_engine_core_inst_Cpu64_1_Local.log
Error description: De opdrachtregel bevat een ongeldig argument. Raadpleeg de SDK van Windows Installer voor uitgebreide Help voor opdrachtregels.
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

Feature: SQL Browser
Status: Passed

Feature: SQL Writer
Status: Passed

Feature: SQL Client Connectivity SDK
Status: Passed

Feature: SQL Client Connectivity
Status: Passed

Rules with failures or warnings:

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

Answer 1

OS region: België
OS language: Nederlands (Nederland)

You are using SQL Server in English on a non-english OS, that can cause problem. Use a NL installer or change temporary the OS language, see https://learn.microsoft.com/en-us/sql/sql-server/install/local-language-versions-in-sql-server?view=sql-server-ver15#BK_ConfigureOS

Answer 2

Hi @Kim ,

This problem is most likely due to the wrong format of the installation file name. Try to find your installation file, are there spaces in your file name? remove the blank space or enter an underscore(_) or any character to replace the blank space.
Remove the failed installation from the server using “Add and Remove Programs”. Finally, start the installation again by a right-click on the setup file and choosing “Run as administrator” option.

if not for this error, Other reasons, like
Remnants of the previous installation that leave orphaned entries in the windows installer registry.
Another service running in the SQL port.
The issue with the Windows temp folder.

Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20211211_095404\sql_engine_core_inst_Cpu64_1_Local.log

you can get more detailed information about this error from this log

-------------

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.

Answer 3

the are no blank between the name.

this is the log

=== Verbose logging started: 12/13/2021 15:07:54 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) (38:54) [15:07:54:533]: Resetting cached policy values
MSI (c) (38:54) [15:07:54:533]: Machine policy value 'Debug' is 0
MSI (c) (38:54) [15:07:54:533]: ******* RunEngine:
******* Product: D:\Downloads\SQLEXPRADV_x64_ENU\x64\setup\sql_engine_core_inst.msi
******* Action:
******* CommandLine: **********
MSI (c) (38:54) [15:07:54:534]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (38:54) [15:07:54:534]: Grabbed execution mutex.
MSI (c) (38:54) [15:07:54:535]: Cloaking enabled.
MSI (c) (38:54) [15:07:54:535]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (38:54) [15:07:54:535]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (B4:0C) [15:07:54:537]: Running installation inside multi-package transaction D:\Downloads\SQLEXPRADV_x64_ENU\x64\setup\sql_engine_core_inst.msi
MSI (s) (B4:0C) [15:07:54:537]: Grabbed execution mutex.
MSI (s) (B4:D8) [15:07:54:538]: Resetting cached policy values
MSI (s) (B4:D8) [15:07:54:538]: Machine policy value 'Debug' is 0
MSI (s) (B4:D8) [15:07:54:538]: ******* RunEngine:
******* Product: D:\Downloads\SQLEXPRADV_x64_ENU\x64\setup\sql_engine_core_inst.msi
******* Action:
******* CommandLine: **********
MSI (s) (B4:D8) [15:07:54:538]: Machine policy value 'TransformsSecure' is 0
MSI (s) (B4:D8) [15:07:54:538]: User policy value 'TransformsAtSource' is 0
MSI (s) (B4:D8) [15:07:54:546]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (B4:D8) [15:07:54:546]: Specified instance {0882B8ED-BBF9-4C84-B1F3-84EEE9BBD95E} via transform :InstID03.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (B4:D8) [15:07:54:546]: MainEngineThread is returning 1639
MSI (s) (B4:0C) [15:07:54:547]: User policy value 'DisableRollback' is 0
MSI (s) (B4:0C) [15:07:54:547]: Machine policy value 'DisableRollback' is 0
MSI (s) (B4:0C) [15:07:54:547]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (B4:0C) [15:07:54:547]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (B4:0C) [15:07:54:547]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (B4:0C) [15:07:54:548]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (38:54) [15:07:54:548]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (38:54) [15:07:54:548]: MainEngineThread is returning 1639
=== Verbose logging stopped: 12/13/2021 15:07:54 ===

Answer 4

Hi,

It is my file:

Recommend re-downloading from official:
https://www.microsoft.com/en-us/Download/details.aspx?id=101064#:~:text=Microsoft%20SQL%20Server%202019%20Express%20is%20a%20free%2C,applications%2C%20and%20for%20redistribution%20by%20ISVs.%20LocalDB%20%28SqlLocalDB%29

---

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.

Answer 5

MSI (c) (84:58) [03:40:06:636]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (84:58) [03:40:06:636]: Grabbed execution mutex. MSI (c) (84:58) [03:40:06:636]: Cloaking enabled. MSI (c) (84:58) [03:40:06:636]: Attempting to enable all disabled privileges before calling Install on Server MSI (c) (84:58) [03:40:06:636]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (F4:18) [03:40:06:636]: Running installation inside multi-package transaction C:\Users\NorayrV\AppData\Local\Temp\IIF473F.tmp\ME_UnLegacy_x64.msi MSI (s) (F4:18) [03:40:06:636]: Grabbed execution mutex. MSI (s) (F4:84) [03:40:06:636]: Resetting cached policy values MSI (s) (F4:84) [03:40:06:636]: Machine policy value 'Debug' is 0 MSI (s) (F4:84) [03:40:06:636]: ******* RunEngine: ******* Product: C:\Users\NorayrV\AppData\Local\Temp\IIF473F.tmp\ME_UnLegacy_x64.msi