Performing a Silent Install of SQL Server Management Studio (2016)

With the release of SQL Server 2016, SQL Server Management Studio (SSMS) is now a stand-alone tool. It requires no licensing and can be downloaded without as much as registering. Because it is a separate download, it requires a separate installation.

The computer labs I manage have SQL Server installed, including Management Studio. Prior to SQL 2016, Management Studio came as part of the SQL Server ISO and silently installing SMSS was part of a silent install of SQL Server. This has changed now: the SQL Server 2016 ISO does not include SSMS anymore and therefore two separate silent installations are required. (Note that silent or unattended installations of SQL Server haven’t changed in 2016.)

Here is how to silently install SQL Server Management Studio:

  1. Download the installer from https://msdn.microsoft.com/en-us/library/mt238290.aspx
  2. Run the silent installer using the following command line:

SSMS-Setup-ENU.exe /install /quiet /norestart

How did I arrive at these switches? By running

SSMS-Setup-ENU.exe /?

you will be presented with a helpful dialog documenting the supported switches.

SSMS installer help showing the supported command line switches
Figure 1: SSMS installer showing the supported command line switches

Other supported modes are uninstall, repair, and layout. It is also possible to set the location of the log file created by the installer.

Advertisements

10 thoughts on “Performing a Silent Install of SQL Server Management Studio (2016)

  1. i would like to automate download as well, is there a config I can read the download link from, so far i have no success.

      1. @Brian: The SSMS installer is completely different than the one with VS (2015 or 2017). It’s an 800MB+ download that is self-contained. I think the questions are surrounding some type of permalink to the latest version so the download itself can be scripted.

    1. Check out a tool called chocolatey. Once installed, you can use it to download and install SSMS like this:
      choco install sql-server-management-studio

      Or upgrade to the latest version like this:
      choco upgrade sql-server-management-studio

      Or update all of your chocolatey packages at once:
      choco upgrade all -y

      1. Hi sqlduck,
        Yes, chocolatey is nice. However, it requires an Internet connection. My scenario called for an offline solution, so chocolatey is not an option there.

    2. Has anyone encountered an issue where when trying to silently install SSMS 2016, it creates two background processes and never comes up with the progress window when using the passive switch?

      If I run the installer manually, everything comes up just fine, but silently it always just does nothing

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s