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)
The following error occurred:
The specified value for setting ‘MEDIALAYOUT’ is invalid. The expected values are:
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)