Solution : Error during setup – The specified value for setting ‘MEDIALAYOUT’ is invalid
Posted by blakhani on November 26, 2014
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
granadacoder said
Thanks!
setup.exe /IACCEPTSQLSERVERLICENSETERMS /configurationfile=”C:\ConfigurationFile.ini”
is the full, correct version, I think. (For future readers)
blakhani said
The command would work for all editions. The edition would be based on PID specified in ConfigurationFile.ini file.
sandlee said
Have you solved the problem? My problem is the same as yours
sandlee said
sorry , you solved it , I did not notice
Ashok Yadav said
I just restarted the server, and the issue got resolved.