As a default service process many hosting providers install Microsoft SQL Server for you. But in some cases this may not happen or you may need to reinstall it for resolving some issues.  Example, if you see an error saying “SQL Server was not installed” then you may need to reinstall the MS SQL again. Following step by step guide will help you to manually install MS SQL Server Express 2014.

Before starting an installation guide, you need to make sure of a couple of things like, choosing the required version of MS SQL from Microsoft’s website and downloading the right type of file like 32 bit or 64 bit.

Once you are done with this all you can simply follow given steps to install MS SQL.

Steps to Install Microsoft SQL Server Express 2014

Step 1: Click on the downloaded file and Run the file.

MS SQL Installation

Step 2: Accept the license terms and click Next.

SQL Installation

Step 3: On the Feature Selection screen, keep the defaults

MS SQL Install Guide

Step 4: On instance configuration screen, select “Named Instance” and name the database you want and click.

KB01_04_Config

Step 5: Click Next until you get to the Database Engine Configuration screen and select Mixed Mode. Don’t forget to save login details and passwords in another document.

KB01_05_DataBase

Step 6: Click Next until your setup is complete. Click Close.

KB01_06_complete

Congratulations! You have successfully installed the MS SQL on your server.