SQL Server 2014 step by step installation guide

In this post, we will discuss SQL Server 2014 step by step installation guide. You can download SQL server 2014 software from the below links:
SQL Server 2014 X64
SQL Server 2014 X86

After downloading the exe file, double click on the exe, it will extract to a folder first.

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Then click on “New SQL Server stand-alone installation on add features to an existing installation” link as shown in the fig below:

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Then accept the license terms as shown in the fig below:

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Then select the checkbox in Microsoft Update screen like below:

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Then in the Feature Selection screen, select all the checkboxes like below:

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

In the Feature Rules screen, it will display Passed or Failed message. Here .Net framework 3.5 service pack 1 was not installed, so it displays the Failed message like below. You can check out this article to solve the issue.

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Once you complete .Net Framework 3.5 installation, click on Re-run see above pics.

Next, in the Instance Configuration screen choose the instance, you can choose Default instance or If you have already installed sql server any version already then you can choose Names instance and can give a name.

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

In the Server Configuration wizard, you can set the Account Name, Startup Type etc as shown in the fig below:

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Then in the Database Engine Configuration wizard, choose Mixed Mode (SQL Server authentication and Windows authentication) option. Then enter your password and confirm password as shown in the fig below:

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Then click on Next. Then it will process and show the successful message. If it requires it will ask you to restart machine. The successful message will show like below.

SQL Server 2014 step by step installation guide
SQL Server 2014 step by step installation guide

Restart and Now you should be able to login to SQL server management studio 2014.

You may like following SQL Server tutorials:

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

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

Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SPGuides.com

>