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. Such as, 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.

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

MS SQL Installation

  1. Accept the license terms and click Next.

SQL Installation

  1. On the Feature Selection screen, keep the defaults

MS SQL Install Guide

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

KB01_04_Config

  1. 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

  1. Click Next until your setup is complete. Click Close.

KB01_06_complete

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