Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

    Advertisements
  • Blog Stats

    • 1,506,594 hits
  • Select GETDATE()

    October 2018
    M T W T F S S
    « Apr    
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  
  • Advertisements

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

Advertisements

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