While trying to install new instance of SQL Server 2014 using command line and configuration file, I was welcomed by below error message
TITLE: SQL Server Setup failure.
——————————
SQL Server Setup has encountered the following error:
The specified value for setting ‘MEDIALAYOUT’ is invalid. The expected values are:
None
Core
Advanced
Full
Error code 0x84B40001.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0x28498E8E%25400x2841E06E%25401204%25401
——————————
BUTTONS:
OK
——————————
The command which I was running was as below
setup.exe configurationfile="C:\ConfigurationFile.ini"
Here is the error on command line.
I went back and looked into log (Detail_LandingPage.txt) files and found below.
(01) 2014-11-26 06:13:38 Slp: Setting: INSTALLMEDIAPATH
(01) 2014-11-26 06:13:38 Slp: Value specified: E:\SQL2014\SQLFull_ENU\x64\setup\
(01) 2014-11-26 06:13:38 Slp: New setting source: CommandLine; previous setting source: NotSpecified
(01) 2014-11-26 06:13:38 Slp: —————————————-
(01) 2014-11-26 06:13:38 Slp: Setting: ENU
(01) 2014-11-26 06:13:38 Slp: Value specified: True
(01) 2014-11-26 06:13:38 Slp: New setting source: CommandLine; previous setting source: Default
(01) 2014-11-26 06:13:38 Slp: —————————————-
(01) 2014-11-26 06:13:38 Slp: Setting: MEDIALAYOUT
(01) 2014-11-26 06:13:38 Slp: Value specified: Full,configurationfile=C:\ConfigurationFile.ini
(01) 2014-11-26 06:13:38 Slp: New setting source: CommandLine; previous setting source: Default
(01) 2014-11-26 06:13:38 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ProcessChainerCommandLineArgumentsAction" threw an exception during execution.
(01) 2014-11-26 06:13:38 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The specified value for setting ‘MEDIALAYOUT’ is invalid. The expected values are:
(01) 2014-11-26 06:13:38 Slp: None
(01) 2014-11-26 06:13:38 Slp: Core
(01) 2014-11-26 06:13:38 Slp: Advanced
(01) 2014-11-26 06:13:38 Slp: Full —> Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: The specified value for setting ‘MEDIALAYOUT’ is invalid. The expected values are:
Well, I didn’t find any documentation that I need to specify the value. If we look closer at the log, it seems that the value which is taken by the parameter is
Full,configurationfile=C:\ConfigurationFile.ini
Wait a second!!! it has parameter which I have specified. I looked into documentation and found that parameter name should start with “/” Since I have not specified the parameter name configurationfile with a slash. Same error can also happen if below is used
setup.exe IACCEPTSQLSERVERLICENSETERMS /configurationfile="C:\ConfigurationFile.ini"
In above, I have missed slash before IACCEPTSQLSERVERLICENSETERMS
Bottom line: Check the setup Logs and find which parameter is not having correct value and what is the value passed and taken from setup.exe
Hope this helps.
Balmukund