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:
- Databases built with Express Edition are limited to 10GB in size.
- Express Edition does not offer the database mirroring, log shipping or publication merging features offered in the larger product.
- SQL Server 2014 Express Edition requires a minimum of 6GB disk space, and 4GB of RAM.
- 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.
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.
Figure 2: Selecting the Correct Version to Download
Step 4: Click here for more information on the download process.
Step 1: Locate the downloaded setup file for Microsoft SQL Server Express 2014.
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.
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.
Figure 5: SQL Server 2014 Processing Current Operation Message
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.
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.
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.
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.
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.
Figure 10: Microsoft Update Window
Step 6: Next, the Install Setup Files window will be shown. Wait for the installation process to finish.
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.