Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 2,050,832 hits
  • Select GETDATE()

    June 2023
    M T W T F S S
     1234
    567891011
    12131415161718
    19202122232425
    2627282930  

Posts Tagged ‘MEDIALAYOUT’

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

Advertisement

Posted in Installation | Tagged: , , | 5 Comments »