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
Check my blog posts on most of the new features released in SQL Server 2016 here https://sqlwithmanoj.com/sql-server-2016-articles/