Install of SQL Server 2017 Express Failed with and error 2147467259 and message "%1 is not a valid Win32 application."

Question

Install of SQL Server 2017 Express Failed with and error 2147467259 and message "%1 is not a valid Win32 application."

Fishinforfacts 21

I have tried installing numerous versions of evaluation in addition to 2017 Express and get the same error every time. From Summary_MikeHP_20201114_140946.txt in C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20201114_140946 I have one error as follows:
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: %1 is not a valid Win32 application.
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=0xA77222DB%400xDC80C325&EvtType=0xA77222DB%400xDC80C325

I have tried to follow the link but it doesn't provide me any info. I am a a loss as to what program (%1) isn't a win 32 app. Also I am running Windows 10 64 bit. I was also running a Basic install. Any suggestions would be appreciated. Thanks.

Accepted answer

6 additional answers

Your answer

Answer 1

m 4,276

Hi @Fishinforfacts ,

I am not sure whether the same cause for this error, however you can take a reference: troubleshooting-1-is-not-a-valid-win32-application

Suggestion:

Uninstall the instance clearly follow this: cleanly-uninstalling-stubborn-sql-server-components,
Reinstall the instance follow steps as this: step-by-step-installation-of-sql-server-2017

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

More information: how-to-completely-uninstall-sql-server, uninstall-an-existing-instance-of-sql-server-setup

Fishinforfacts 21 Reputation points

2020-11-17T00:24:50.003+00:00

This worked and I was able to install finally. Thanks for your assistance.

Answer 2

Erland Sommarskog 121.4K MVP Volunteer Moderator

That sounds like a broken download to me. I would try downloading again. If possible over a different network connection.

Answer 3

Fishinforfacts 21

I have downloaded each of these versions multiple times and the result is always the same. I will try to download through a different network and see if it makes a difference.

Answer 4

Fishinforfacts 21

I down loaded using a different computer over a different network and tried installing on both machine and got the same result. It still gives me a not a Win32 App. The only difference in that I downloaded to media as opposed to running the basic install. Any other ideas?

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-14T22:00:54.877+00:00

Did you try installing on that other computer?

The next guess is that there is something "evil" on your machine which mutilates the Setup.

Is it your own personal computer, or is it a corporate machine?
Fishinforfacts 21 Reputation points

2020-11-14T23:29:52.403+00:00

Both machine are mine. I have not had any issues installing any other software including MYSQL just 2 days ago. I have been using PCs since 1980 and this is the first time I have encountered anything like this. A couple of times today I have completely removed all failed attempts from my system and nothing seems to help
Fishinforfacts 21 Reputation points

2020-11-14T23:39:17.257+00:00

Yes I tried to install on both computers and they both failed.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-15T10:58:24.587+00:00

If the download media would be broken at the source, it would be all over town, so I'm inclined to think that it is something in your environment, but we may have to look at this a little more closely.

For each installation attempt there is a folder in C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log. In these folders there are a number of files, all quite verbose. The best to start with is Details.txt. Could it be that the install is trying to use an executable program that comes with Windows, but which is corrupted on your computers? The log file is certainly a lot to get through, but have a look at it.
Fishinforfacts 21 Reputation points

2020-11-15T11:55:36.717+00:00

I appreciate your help. I will research it and get back to you. I have to try to install it again because every I have uninstalled it and all of the files have been been deleted. Sorry.

Answer 5

I tried again and it failed in the same way. here is an excerpt from the Log.

17:00:52 Slp: Running Action: SqlSkuConfig_install_ConfigNonRC_Cpu64
(01) 2020-11-15 17:00:52 Slp: Action Data:
(01) 2020-11-15 17:00:52 Slp: Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
(01) 2020-11-15 17:00:52 Slp: Scenario = install
(01) 2020-11-15 17:00:52 Slp: Timing = ConfigNonRC
(01) 2020-11-15 17:00:52 Slp: ConfigObjectType = Microsoft.SqlServer.Configuration.SetupExtension.SkuPrivateConfigObject
(01) 2020-11-15 17:00:52 Slp: FeatureSkuCode = SQL
(01) 2020-11-15 17:00:52 Slp: FeatureName = SQL_Engine_Core_Inst
(01) 2020-11-15 17:00:52 Slp: FeatureCpuType = Cpu64
(01) 2020-11-15 17:00:52 Slp: FeaturePackageId = sql_engine_core_inst
(01) 2020-11-15 17:00:52 Slp: -- SkuPrivateConfigObject : Parsed FeatureSkuCode is 'SQL'.
(01) 2020-11-15 17:00:52 Slp: -- SkuPrivateConfigObject : FeatureSkuCode 'SQL' produced registryPath 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.SQLEXPRESS01\Setup'.
(01) 2020-11-15 17:00:52 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2020-11-15 17:00:52 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\140
(01) 2020-11-15 17:00:52 Slp: Sco: Attempting to get registry value SharedCode
(01) 2020-11-15 17:00:52 Slp: Sco: Attempting to load sqlboot.dll from C:\Program Files\Microsoft SQL Server\140\Shared\sqlboot.dll
(01) 2020-11-15 17:00:52 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
(01) 2020-11-15 17:00:52 Slp: %1 is not a valid Win32 application.

(01) 2020-11-15 17:00:52 Slp: The configuration failure category of current exception is ConfigurationFailure
(01) 2020-11-15 17:00:52 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
(01) 2020-11-15 17:00:52 Slp: System.ComponentModel.Win32Exception (0x80004005): %1 is not a valid Win32 application.
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.Sco.SqlbootModule.get_Handle()
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SetupExtension.SkuPublicConfigObject.BuildSkuInfo(SkuCheckSumInfo& skuCheckSumInfo, Boolean createNewTimeStamp)
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SetupExtension.SkuPublicConfigObject.InstallSkuInfo(String registryPath, RegistryView[] registryViewList, Boolean writeEditionStrings)
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SetupExtension.SkuPrivateConfigObject.Install(ConfigActionTiming timing, Dictionary2 actionData, PublicConfigurationBase publicConfigBase) (01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary2 actionData, PublicConfigurationBase spcbCurrent)
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary2 actionData, PublicConfigurationBase spcbCurrent) (01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SetupExtension.SkuPrivateConfigObject.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary2 actionData, PublicConfigurationBase spcbCurrent)
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2020-11-15 17:00:52 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2020-11-15 17:00:52 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2020-11-15 17:00:52 Slp: Inner exceptions are being indented
(01) 2020-11-15 17:00:52 Slp:
(01) 2020-11-15 17:00:52 Slp: Exception type: System.ComponentModel.Win32Exception
(01) 2020-11-15 17:00:52 Slp: Message:
(01) 2020-11-15 17:00:52 Slp: %1 is not a valid Win32 application.

I don't see which program is causing the problem from here. I am just going to forget about it, as I can use MySQL to accomplish what I want, so please don't waste any more time. If it is something obvious then I will try one more time to resolve the problem. Thanks for your help.

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2020-11-16T22:30:22.397+00:00

My interpretation is that the faulty file is
C:\Program Files\Microsoft SQL Server\140\Shared\sqlboot.dll
which is not very helpful, since we will have to assume that this file comes with the install.

...unless the file was there already and Setup fails to overwrite it? But that sounds extremely far-fetched.

For what it's worth, when I do

dir C":\Program Files\Microsoft SQL Server\140\Shared\sqlboot.dll"

on my system, it reports a size of 190856 bytes. If you see something different, you could try removing the file and try again.

Then again, you have already said that you have abandoned your attempts to install SQL Server.

Share via

Install of SQL Server 2017 Express Failed with and error 2147467259 and message "%1 is not a valid Win32 application."

6 additional answers

Your answer