It’s time to install SQL Server 2016


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:

SQL Server 2016 Feature list 2016 vs SQL Server 2014 Feature List

SQL Server 2016 Feature list 2016 vs SQL Server 2014 Feature List

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:

SQL Server 2016 vs SQL Server 2014 Installation - First screen comparison

SQL Server 2016 vs SQL Server 2014 Installation – First screen comparison

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

SSMS 2016 installation

SSMS 2016 installation

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.

 

Rate This
[Total: 5    Average: 3.4/5]

Gopal Krishna Ranjan

About Gopal Krishna Ranjan

Gopal has 8 years of industry experience in Software development. He has a head down experience in Data Science, Database, Data Warehouse, Big Data and cloud technologies and has implemented end to end solutions. He has extensively worked on SQL Server, Python, Hadoop, Hive, Spark, Azure, Machine Learning, and MSBI (SSAS, SSIS, and SSRS). He also has good experience in windows and web application development using ASP.Net and C#.

Leave a comment

Your email address will not be published. Required fields are marked *