Home > SQL Server 2016 > Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)

Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)

In my [previous blog] post of SQL Server 2016 RC0 availability, I mentioned regarding SQL Server Management Studio (SSMS) that it will no longer be installed from the main feature tree of SQL Server engine setup.

As per Microsoft, this is basically to support the move to make a universal version of SSMS that ships every month or so.

So, now on wards after installing SQL Server 2016 you need to install SSMS separately.

–> Till SQL Server 2014 you have an option of choosing SSMS in the Feature selection tree, but with SQL Server 2016 and on wards this option is taken out, can be seen in the pic below:

–> Now to download SSMS 2016 you can either visit the Microsoft [download page]

Or, try installing directly via the “Installation Center” as shown below. This will install SSMS directly online.

So, once you take appropriate action above to download SSMS 2016, the Installation kicks off like this:

And here is the version information of SSMS 2016 after successful installation:

Microsoft SQL Server Management Studio	 13.0.12000.65
Microsoft Analysis Services Client Tools 13.0.1100.213
Microsoft Data Access Components (MDAC)	 10.0.10586.0
Microsoft MSXML				 3.0 6.0 
Microsoft Internet Explorer		 9.11.10586.0
Microsoft .NET Framework		 4.0.30319.42000
Operating System			 6.3.10586


Tech Tip: Move your SQL server onto the cloud with Hosted Citrix VDI available unbelievable citrix xendesktop pricing and get an easy remote access to it from anywhere on any device(PC/Mac/Linux/android/iOS) powered by one of the leading providers of cloud hosting – Apps4Rent.


Check my blog posts on most of the new features released in SQL Server 2016

  1. Dinesh Kumar
    March 28, 2020 at 6:29 pm

    Thanks for your comments. It helps me allot as you attached the screen shot because last i installed sql server 2014 which asked lots of options to selected but in sql server no need to selected any options. Thanks.

  1. June 1, 2016 at 11:32 pm
  2. January 1, 2018 at 5:10 pm
  3. January 1, 2019 at 10:27 pm

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: