SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid

I was helping a client to install SQL Server using script/automation (without using UI). They wanted to do command-line install rather than hitting next, next, fill values in the UI as they have to deploy more than 100 servers with SQL installed on it. In this blog we would learn about how to fix SQL Setup installation error – “The specified value ‘Install’ for ACTION is invalid.”

When my client first contacted me, they just told the error and as always, I asked for the setup log file. I had no idea how they were installing it. When I investigated the setup bootstrap log file, here is what I saw:

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2057043952
Exit facility code: 1380
Exit error code: 16
Exit message: The specified value ‘Install’ for ACTION is invalid. To run in unattended mode, you must specify a valid ACTION. The valid values for ACTION are: None RemovePatch Uninstall Install Upgrade Patch Repair LandingPage ClusterReport RunRules PrepareFailoverCluster CompleteFailoverCluster InstallFailoverCluster RemoveNode AddNode EditionUpgrade Bootstrap ComponentUpdate Help RebuildDatabase RunDiscovery PrepareImage CompleteImage ConfigureImage
Start time: 2018-07-12 17:05:33
End time: 2018-07-12 17:05:35
Requested action: None

When I looked further in the log, I could see below:

User Input Settings:
ENU: false
HELP: false
QUIET: false
UIMODE: Normal
X86: false

After few lines, I found this.

WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.InvalidWorkflowException@16
DisableWatson = true
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveInputSettingValueToObjectEnum(
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveParsedArgumentsIntoSettings(
at Microsoft.SqlServer.Configuration.BootstrapExtension.ProcessChainerCommandLineArgumentsAction.ExecuteAction(
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.b__b(
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(
Inner exception type: System.ArgumentException
Requested value ”Install” was not found.
HResult : 0x80070057
at System.Enum.EnumResult.SetFailure(
at System.Enum.TryParseEnum(
at System.Enum.Parse(

This was strange because not many parameters are visible in the first section and then I see (notice two single quotes)

Requested value ”Install” was not found.

I asked them a screenshot of the error and they share below with me:

SQL SERVER - Installation Error: The Specified Value 'Install' for ACTION is Invalid install-cmd-err-01


After this, I realize that due to single quotes around Install action, setup is parsing it incorrectly and thinking ‘install’ as an action. I checked the documentation and indeed single quotes for a parameter value is not valid.

Once we replace the single quote with a double quote on the command prompt, setup moved forward but there was a new error, which I would blog later.

Have you faced similar issue earlier?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL Error Messages, SQL Log, SQL Server
Previous Post
SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata
Next Post
SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable

Related Posts

Leave a Reply