Download & Installation SQL Server 2016 and Management Studio 2017

In this SQL Server tutorial, we will discuss how to download SQL server 2016 and step by step tutorial on how to install SQL server 2016 and how to install SQL Server management studio 2017. We were going to install in Windows server 2016 laptop.

SQL Server 2016 Downloads

Below are few SQL Server download Links (180 Days FREE Evaluation Version):

Note: If you have visual studio enterprise subscription, then you can search for the particular SQL Server version and you will be able to download.

SQL Server 2016 Installation Steps

Before installing SQL Server, you can read an article on Hardware and Software Requirements for Installing SQL Server.

Once you download SQL Server 2016, double-click on the setup file to start SQL server 2016 installation.

This will open the “SQL Server Installation Center” wizard. In “Installation” Click on “New SQL Server stand-alone installation or add features to an existing installation” as shown in the fig below:

 sql server 2016 installation
sql server 2016 installation

Then it will ask for the product key since I have downloaded from visual studio subscription, I do not need to put a product key.

sql server 2016 installation step by step pdf
sql server 2016 installation step by step pdf

Click on Next. The in the License Terms, accept the terms.

sql server 2016 download
sql server 2016 download

Click on Next.

sql server 2016 installation steps
sql server 2016 installation steps

Then in the Install Rules page, it will check for various Rules. Make sure all the Rules will be either Passed or Warning. There should not be any error.

sql server 2016 installation best practices
sql server 2016 installation best practices

Then in the Feature Selection, check the features you need to install. Here I have choosen all the features.

sql server 2016 installation step by step
sql server 2016 installation step by step

Then again it will run the Feature Rules again. Once all the Rules are Passed, click on Next.

sql server 2016 installation step by step
sql server 2016 express download

Then choose Default instance (MSSQLSERVER) like below:

sql server 2016 enterprise edition download
sql server 2016 enterprise edition download

Then it will display the service accounts used for different services like below:

sql server 2016 installation steps
sql server 2016

Then choose the Authentication Moder as Mixed Mode (SQL Server Authentication and Windows authentication) and then enter the password and click on Next.

 microsoft sql server 2016 download
microsoft sql server 2016 download

Since I have chosen the Reporting services, in the “Reporting Services Configuration”, I choose ” Install only” like below:

sql server 2016 express with advanced services offline installer
sql server 2016 express with advanced services offline installer

In the Distrubted Replay Controller screen provide the account details for permission. You can just click on “Add Current User” button like below:

sql server 2016 installation
sql server 2016 installation

It will autopopulate, Controller Name, Working Directory and Result Directory details like below:

sql server 2016 installation steps
sql server 2016 installation steps
download sql server 2016
download sql server 2016

Then in the “Ready to Install” screen it will display all the services you have choosen to install like below:

sql server management studio
sql server management studio

Once click on Install, SQL server 2016 installation will start like below:

sql server management studio 2017
sql server management studio 2017

You can see in the below screen my “Integration Services” is failed, Since I do not need this I just ignore. Else you have to first fix the issue and then reinstall again.

sql server 2016 installation step by step
sql server 2016 installation step by step

Now you can see the installation is complete with below two error.

  • R-Services (In-Database) feature.
  • Integration Service
sql server 2017 installation step by step
sql server 2017 installation step by step

This finished our SQL Server 2016 installation. Now we will see how we can install SQL Server management studio 2017.

Install SQL Server Management Studio:

First Download SQL Server Management Studio 17.8.1 and then run the setup file, after which the below screen will appear. Clickon the Install button to start SQL Server management studio installation.

sql server management studio 2017
sql server management studio 2017

The installation will start.

sql server management studio
sql server management studio

It will show the progress like below:

download and install sql server 2016
sql server management studio 2017

Once the installation will over, you will be able to open SQL Server management studio 2017.

Here we discussed how to download and install SQL server 2016 step by step tutorial and also we saw how to install SQL server management studio 2017.

You may like following SQL server tutorials:

Few people search for similar tags: sql server 2016, sql server 2016 installation, sql server 2016 installation steps, download sql server 2016, sql server management studio, sql server management studio 2017, sql server 2016 installation step by step, sql server 2017 installation step by step, sql server 2016 express download, sql server 2016 sp1 download.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>