Advertisements
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:

SSMS 2014 vs 2016 01
 

–> 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.

SSMS 2014 vs 2016 02
 

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

SSMS 2014 vs 2016 03

SSMS 2014 vs 2016 04

SSMS 2014 vs 2016 05

 

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

 

Check my blog posts on most of the new features released in SQL Server 2016 here https://sqlwithmanoj.com/sql-server-2016-articles/
 

ssms-2016-download
 


Advertisements

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

%d bloggers like this: