Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

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

    November 2014
    M T W T F S S
     12
    3456789
    10111213141516
    17181920212223
    24252627282930

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

5 Responses to “Solution : Error during setup – The specified value for setting ‘MEDIALAYOUT’ is invalid”

  1. 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.

  2. sandlee said

    Have you solved the problem? My problem is the same as yours

  3. Ashok Yadav said

    I just restarted the server, and the issue got resolved.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: