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.
SharePoint Tutorial Contents
SQL Server 2016 Downloads
Below are few SQL Server download Links (180 Days FREE Evaluation Version):
- SQL Server 2017 RTM
- SQL Server 2017 Express Edition (FREE)
- SQL Server 2017 Developer Edition (FREE)
- Download SQL Server Management Studio 17.8.1
- SQL Server 2016 with SP1
- SQL Server 2016 Express Edition
- SQL Server 2014 SP2
- SQL Server 2014 Express (64-Bit)
- SQL Server 2014 Express (32-Bit)
- SQL Server 2014 Management Studio(64-Bit)
- SQL Server 2014 Management Studio(32-Bit)
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:
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.
Click on Next. The in the License Terms, accept the terms.
Click on Next.
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.
Then in the Feature Selection, check the features you need to install. Here I have choosen all the features.
Then again it will run the Feature Rules again. Once all the Rules are Passed, click on Next.
Then choose Default instance (MSSQLSERVER) like below:
Then it will display the service accounts used for different services like below:
Then choose the Authentication Moder as Mixed Mode (SQL Server Authentication and Windows authentication) and then enter the password and click on Next.
Since I have chosen the Reporting services, in the “Reporting Services Configuration”, I choose ” Install only” like below:
In the Distrubted Replay Controller screen provide the account details for permission. You can just click on “Add Current User” button like below:
It will autopopulate, Controller Name, Working Directory and Result Directory details like below:
Then in the “Ready to Install” screen it will display all the services you have choosen to install like below:
Once click on Install, SQL server 2016 installation will start like below:
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.
Now you can see the installation is complete with below two error.
- R-Services (In-Database) feature.
- Integration Service
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.
The installation will start.
It will show the progress like below:
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:
- Install and Configure SQL Server Reporting Services Service Application in SharePoint 2010
- microsoft sql server 2012 native client download error sharepoint 2016
- Install and configure SQL server reporting services (SSRS) in SharePoint 2013/2016
- Configure SQL Server Analysis Services (SSAS) in SQL Server 2012 Step by step guide
- Create a user and give permission in SQL Server
- Download and Install SQL Server 2014 SP1 in Windows Server 2016
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.
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com