Deploying SQL Server 2016 Management Tools

TL;DR SSMS is now a separate 800MB+ download.

Long story (Begin Rant):

As much as I can, I always deploy Windows features and products using either direct to command line or with a configuration XML or INI file. In this case, I am installing SQL Server.


On previous version of SQL Server you can use the INI file to indicate what features you are going to install. Syntax is FEATURES=<FEATURE><,><FEATURE>


And before you can add the SSMS feature by adding SSMS –or- ADV_SSMS for Management Tool Basic –or- Advanced, respectively.

There seems to be a change with SQL Server 2016 as adding the SSMS will throw an install error.

So I saw the Management Tools now  located in the installation tab and under the new stand-alone link. I remember that in order for me to add SSMS before, it is under the add features to an existing installation. But now it seems that SSMS has its own link. But be warned, it is an actual “HREF” to a webpage.


Yes. You guess it right, you have to download SSMS as a separate installer.


That link, Download SQL Server Management Studio (16.5.3): is 898MB. Surprise!


Now using Philippine internet connection: See you after 3 hours or more.


So after downloading we can now launch the installer.


Next time, I will be using /Install /Quiet as my command line parameters based on the MSDN article here: but for now, lets do a GUI install.


Wait for the setup to finish. This will not ask for your install location nor what tool to install – it will install everything on your C:\Program Files so be careful if you have SSD. Hope in the future, since this is a standalone product that we can choose which drive to use. But for now its just a straight forward install.



So after installation, launch..


We now have SSMS back!


Published by


John is currently creating digital assets that protects people and their future, a technical trainer and a full time geek specializing on development and deployment of innovations created with .NET framework on Windows platform as well as Windows infrastructure projects. He is the primary contact of the Philippine Windows Users Group, a contributor at the Microsoft Philippines Community forums and regularly conducts community sessions as well as other Microsoft technology events. John owns the Busy Saving The World Techblog.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s