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.
Feature Selection Window
Figure 12: Feature Selection Window


Note

It is highly recommend NOT to choose all the features on a production server if you do not require all of them.



Step 8: The Instance Configuration window will then be shown. Select "Named Instance" and name the database accordingly. Click Next.
Instance Configuration Window
Figure 13: Instance Configuration Window


Note

The Server Instance Name will be used as reference when initializing a fresh database in xPortalNet software for first time installations. Users are advised to note down the information entered in the Named Instance field.



Step 9: If a "Please Wait..." message window appeared, please be patient and wait for the application to sort the process out.
Please Wait... Message Window
Figure 14: "Please Wait…" Message Window


Step 10: At the Server Configuration window, users are strongly advised not to play around with these setting and leave them in the default settings. Click Next.
Server Configuration Window
Figure 15: Server Configuration Window


Step 11: The Database Engine Configuration window will then be shown. Specify the Database Engine authentication mode as Mixed Mode, key-in the password for the Mixed Mode authentication, and add the current user as administrator. Click Next to continue.
Database Engine Configuration Window
Figure 16: Database Engine Configuration Window

  1. Authentication Mode, select Mixed Mode
  2. To specify the password for the SQL Server system administrator (sa) account: Enter password and confirm password.
  3. To specify SQL Server administrators: select Add Current User


Note

The Mixed Mode password will be used when initializing a fresh database in xPortalNet software for first time installations. Users are advised to note down the password.



Step 12: At the Reporting Services Configuration window, select Install and configure. Click Next.
Reporting Services Configuration Window
Figure 17: Reporting Services Configuration Window


Step 13: At the Feature Configuration Rules window, wait until all the operations are passed, and then click Next.
Feature Configuration Rules Window
Figure 18: Feature Configuration Rules Window


Caution!

If users are installing Microsoft SQL Server Express using an instance name that was previously uninstalled from the same computer, the following error messages in Feature Configuration Rules window will be shown as below:

  • "Reporting Service Catalog Database File Existence – Failed"
  • "Reporting Service Catalog Temporary Database File Existence – Failed"


Figure 19: Failure Messages in Feature Configuration Rules Window


Cause:
These errors occur due to a clash in name between the existing SQL database and the currently installing SQL database. To solve the issues:

  • Go to SQL Server root directory, by default C:\Program Files\Microsoft SQL Server\MSSQL12.Instance Name\MSSQL\DATA to move, rename or delete the following files:

 1. ReportServer.mdf
 2. ReportServer_log.LDF
 3. ReportServerTempDB.mdf
 4. ReportServerTempDB_log.LDF.

  • Or, use a different instance name.



Step 14: The Installation Progress window will then be shown to indicate the installation progress. Wait for the installation process to finish.
Installation Progress Window
Figure 20: Installation Progress Window


Step 15: Upon completing the installation, click Close to exit from the SQL Server Express 2014.
Completion of the Installation
Figure 21: Completion of the Installation


Step 16: Restart the computer to allow the SQL Server database to launch.

Common Issues:

NIL

Date Documentation:

22/11/2018 (Rev 1.0)

PROOF-READ

.

.


.

© MicroEngine Technology Sdn Bhd (535550-U). All rights reserved.