SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.

There are many DBAs who like to automate the deployment of SQL. It is not fun to use wizard in all the installations. Imagine that setup media is kept in a remote share and all you need to do is provide a batch file to run and it would take care of installation. Let us learn How to Install SSMS From Command Line?

One of my client was trying to do the same. They wanted to deploy SQL Server Management Studio, SSMS, via command line. They contacted me and informed that installation via command is not working and they are getting an error. I asked to share command and the log file.

Here is the command to install Basic SSMS (no advanced features)

\\INDIA-FS1\Softwares\Microsoft\”SQL Server”\”SQL 2014″\”Enterprise Edition”\setup.exe /ACTION=Install /Q /IACCEPTSQLSERVERLICENSETERMS /FEATURES=Conn,BC,SSMS

Here was the error on command line (in my lab server for SQL 2016)

SQL SERVER - How to Install SSMS From Command Line? Error: The Specified Value for Setting 'MEDIALAYOUT' is Invalid. ssms-cmd-01-800x349

The following error occurred:
The specified value for setting ‘MEDIALAYOUT’ is invalid. The expected values are:

WORKAROUND/SOLUTION

My client was using double quotes to make sure that spaces are handled. But instead of putting quotes around each folder having space, they need to put the complete setup.exe path in double quotes. Here is the modified version of the command line.

“\\INDIA-FS1\Softwares\Microsoft\SQL Server\SQL 2014\Enterprise Edition\setup.exe” /ACTION=Install /Q /IACCEPTSQLSERVERLICENSETERMS /FEATURES=Conn,BC,SSMS

After using the above command, they were able to install SSMS and other components.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Command Line, SQL Error Messages, SQL Server, SQL Server Installation, SQL Server Management Studio, SSMS
Previous Post
SQL SERVER – Observation – Adding a NULL Column and Table Space
Next Post
SQL SERVER – Alternate to AGENT_DATETIME Function

Related Posts

Leave a Reply