Download and Install SQL Server 2014 SP1 in Windows Server 2016

This SQL Server tutorial will discuss how to download and install SQL server 2014 and also we will see how to download and install Sql Server 2014 SP1 (service pack 1). Step-by-step procedure for installing a new instance of SQL Server 2014 using the SQL Server setup installation wizard in windows server 2016.

In the first part, we will discuss how we can download and install SQL Server 2014 and then we will see how we can install SQL Server 2014 SP1.

Download SQL server 2014

To install SQL Server 2014, first, download the SQL Server 2014 from this MSDN Link. Since we are installing SQL Server 2014 for SharePoint 2016, we have downloaded and installed the 64-bit version.

Install SQL Server 2014

Once you download, click on the setup file to start the installation and follow below steps given:

Step-1:-
Go to the SQL installation center and then click on the “New SQL Server stand-alone installation or add features to an existing installation”.

install sql server 2014
install sql server 2014

Step-2:-
In this “New SQL Server stand-alone installation or add features to an existing installation”, it will extract here and a SQL server 2014 Setup will open. In this setup, put a check on the check box of “I accept the license terms” and then click on next as given in the figure.

install sql server 2014 service pack 1
install sql server 2014 service pack 1

Step 3:-
In “Global Rules”, here the rule check in progress as shown in given below. Make sure it will show the successful status, if any errors are there, we need to fix before proceeding.

install sql server 2014 SP1
install sql server 2014 SP1

Step-4:-
In “Microsoft Update”, here you can optionally select the checkbox to check for the update and click next.

install sql server 2014 on windows server 2012 r2
install sql server 2014 on windows server 2012 r2

Step 5:-
In “Install Setup Files”, it will show you that the update will be installed as below.

how to install sql server 2014 step by step pdf
how to install sql server 2014 step by step pdf

Step 6:-
In “Feature Selection”, check all the ‘Instance Features’ are checked or not. If not then put a check on that and click on next.

how to install SQL Server 2014 Management Studio
how to install SQL Server 2014 Management Studio

Step 7:-
In “Feature Rules” section, make sure all the rules status should be passed. You can see the below screen shot, there is an issue with Microsoft .NET Framework 3.5 service pack 1 is required. We need to fix the issue before proceeding further. You can follow this article to fix the issue. And then you can click on Re-run button to recheck again. Once the operation will be completed and both the status shows Success, click on next.

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

Step 8:-
In “Instance Configuration”, select the ‘Default instance’ and click next as below in the figure.

SQL Server 2014 SP1
SQL Server 2014 SP1

Step 9:-
In “Server Configuration”, go to the ‘Service Accounts’ and select the ‘SQL Server Database Engine’ as Automatic Start up Type and then click to next.

sql server 2014 management studio download
sql server 2014 management studio download

Step 10:-
In “Database Engine Configuration”, click on ‘Server Configuration’ and select the ‘Mixed Mode (SQL server authentication and Windows authentication)’. After that enter your password in ‘Enter password’ and again re-enter your password to confirm in ‘Confirm password’ and click on next.

install sql server 2014 on windows server 2016
install sql server 2014 on windows server 2016

Step 11:-
In the “Installation Progress”, here the installation will happen and it will complete after some time as shown in the given below.

microsoft sql server 2014 enterprise edition free download
microsoft sql server 2014 enterprise edition free download

Hence we installed the SQL server 2014 in windows server 2016 by using these several steps which are mentioned in above. Now we will discussed about how we can install sql server 2014 SP1.

Download SQL server 2014 SP1 (Service Pack 1)

To install of SQL Server 2014 SP1, first download SQL Server 2014 SP1 from this MSDN URL. And then click on the exe file and follow below steps for installation.

Install SQL Server 2014 SP1

Step 1:-
In “License Terms”, select the check box of ‘I accept the license terms’ and click on next.

how to install sql server 2014 sp1
how to install sql server 2014 sp1

Step 2:-
In the “Select Features”, select ‘MSSQLSERVER’ (if not selected), and then click on next as given in the figure.

SQL Server 2014 SP1
SQL Server 2014 SP1

Step 3:-
In “Check Files in Use”, here files are checking until it is not completing. Once the checking files is done then click to next.

steps to install sql server 2014 sp1
steps to install sql server 2014 sp1

Step 4:-
In “Ready to update”, the file path is configuring. After configuration the file path, go to update and click that as shown in the figure.

install sql server 2014 sp1
install sql server 2014 sp1

Step 5:-
In the “Update Progress”, here the ‘MSSQLSERVER’ is updating. After updating, click on next.

SQL Server 2014 SP1 installation steps
SQL Server 2014 SP1 installation steps

Step 6:-
In the “Install Setup Files”, here the update will be installed as shown in the below and the installation will be done.

SQL Server 2014 SP1 installation step by step tutorial
SQL Server 2014 SP1 installation step by step tutorial

Once the installation over, you will be able to open the sql server 2014 management studio.

You may like following SQL Server tutorials:

Hence we installed the SQL server 2014 and SQL-Server-2014-SP1 in windows server 2016 by using these several steps which are mentioned above. The same steps we can follow to install SQL-Server-2014-SP1 in windows server 2012 r2.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

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

>