Microsoft has launched the SQL Server 2016. We can download and install it from here. However, when we start installation of SQL Server 2016, we can see some installation changes there. Prior to SQL Server 2016, “SQL Server Management Studio (SSMS)” was a part of the feature list of main SQL Server installation (which starts after clicking on “New SQL Server stand-alone installation or add features to an existing installation“) but now it is available on a separate install. Below is the screen shot of the feature selection list of SQL Server 2016 and SQL Server 2014:
In above image, we can see that the management tools was a feature of the core SQL Server installation process in SQL Server 2014 (right side image) but in SQL Server 2016 (left side image), it is not available in the feature list of SQL Server installation process. So, even if we will do a full installation of SQL Server 2016 by selecting all features, we would not be able to get SQL Server Management Studio installed on our machine.
Lets have a look on the first screen of SQL Server 2016 and SQL Server 2014 installation process which comes after opening the setup.exe file:
In this image we can see that the SQL Server Management Studio is now available on a separate line in SQL Server 2016. We can download and install it from here.
Once we click on the above link, we will get a web page with a download link to SQL Server Management Studio (SSMS):
We can download and install the “SSMS-Setup-ENU” file from here. Once the download gets completed, we can open the installer file and follow the steps to install SQL Server Management Studio on our machine.
SQL Server 2016 has brought lots of new features which we can start exploring once we install it.
Thank you for the reading. Please like, share, and comment on the post.