How to Install Microsoft SQL Server Express 2014

Problem (Issue) Statement:

How to install Microsoft SQL Server Express 2014

Description:

A guide to install Microsoft SQL Server Express 2014 software.

Related Software:

  • SQL Server Express 2014 (Version: 12.0.2269)

Related Hardware:

NIL

System Application:

NIL

Symptom and Finding:

NIL

Cause:

For first time installation of Microsoft SQL Server Express 2014 software as a pre-requisite installation to the xPortalNet software.

Solution:

Summary:


Step-by-step Guide:

  • SQL Server Express 2014 Introduction:

Step 1: There are some limitations to SQL Server Express 2014 Edition that you should understanding. These limitations include:

  1. Databases built with Express Edition are limited to 10GB in size.
  2. Express Edition does not offer the database mirroring, log shipping or publication merging features offered in the larger product.
  3. SQL Server 2014 Express Edition requires a minimum of 6GB disk space, and 4GB of RAM.
  4. Supported operating systems include Windows 10, 7 and 8, Windows Server 2008 R2 and Windows Server 2012.



  • Pre-Requisite installation:

Step 1: Users are required to enable Microsoft .Net Framework 3.5 SP1 or download and install Microsoft .Net Framework 4.0.





  • Download the SQL Server Express Installer:

Step 1: Click here to download the Microsoft SQL Server Express 2014.


Step 2: Select the appropriate language and click Download.
Downloading Microsoft SQL Server 2014 Express Edition
Figure 1: Downloading Microsoft SQL Server 2014 Express Edition


Step 3: Choose whether to download the 32-bit or 64-bit version of SQL Server depending on the operation system specification. Click Next to continue.
Selecting the Correct Version to Download
Figure 2: Selecting the Correct Version to Download


Tips

Users are advised to choose "Express with Advance Servers (SQLEXPRADV)" option. The download file will be around 1+GB.



Step 4: Click here for more information on the download process.


  • File Extraction:

Step 1: Locate the downloaded setup file for Microsoft SQL Server Express 2014.
The Downloaded Setup File in the Download Folder
Figure 3: The Downloaded Setup File in the Download Folder


Step 2: Run the SQLEXPRADV_x64_ENU.exe setup file. It will extract the file required for the setup process, which may take up to 5 or 10 minutes.
Microsoft SQL Server 2014 Express Extraction Process
Figure 4: Microsoft SQL Server 2014 Express Extraction Process


Step 3: The extraction window will then disappear after the extraction process completes. Wait until the following window is shown.
SQL Server 2014 Processing Current Operation Message
Figure 5: SQL Server 2014 Processing Current Operation Message


  • Installation guide:

Step 1: The SQL Server Installation Center window (Installation tab) will then be shown. Click New SQL Server stand-alone installation or add features to an existing installation to continue the process.
SQL Server Installation Center Window under Installation Tab
Figure 6: SQL Server Installation Center Window under Installation Tab


Step 2: The "Please wait while Microsoft SQL Server 2014 Setup processes the current operation" message will be shown again.
Please Wait While Microsoft SQL Server 2014 Setup Processes the Current Operation Message Window
Figure 7: "Please Wait While Microsoft SQL Server 2014 Setup Processes the Current Operation" Message Window


Step 3: The License Terms window will then be shown. Tick the "I accept the license terms." Checkbox and click Next to continue.
License Terms Window
Figure 8: License Terms Window


Step 4: At the Global Rules window, the Setup application will run multiple checks for rules during the installation process. If a rule check fails, the setup application will provide the corrective measures to be taken so that the installation can proceed.
Global Rules Window
Figure 9: Global Rules Window


Step 5: The Microsoft Update window will then be shown. Tick the check box on "Use Microsoft Update to check for an update" and click Next.
Microsoft Update Window
Figure 10: Microsoft Update Window


Step 6: Next, the Install Setup Files window will be shown. Wait for the installation process to finish.
Install Setup Files Window
Figure 11: Install Setup Files Window


Step 7: At the Feature Selection window, users can customize the SQL
Server feature to be installed in the PC system.