Silent install – SQL Server Management Studio

I often install SQL Server Management Studio (SSMS) for a range of users – testers, developers etc. – who do not need to use a local database on their workstation.

To reduce my own workload, I’ve generated a command-line script to install the required components.  Using the resources at the MSDN site

http://msdn.microsoft.com/en-us/library/ms144259.aspx

it is pretty simple to generate a command-line script. I use the following script:

“\\networklocation\setup.exe” /ACTION=INSTALL /QUIET /IAcceptSQLServerLicenseTerms=”True” /FEATURES=CONN,BC,SSMS

The main thing to remember is that when you install, make sure that you have enough permissions on the target machine. Also you must be able to ‘see’ the network location where you have your SQL installation media.