...
Problem (Issue) Statement: | How to install Microsoft SQL Server Express 2014 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description: | A guide to install Microsoft SQL Server Express 2014 software. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Related Software: |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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:
|
Anchor | ||||
---|---|---|---|---|
|
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:Anchor 2 2
Step 1: Users are required to enable Microsoft .Net Framework 3.5 SP1 or download and install Microsoft .Net Framework 4.0.
Info | ||
---|---|---|
| ||
Knowledge Base Link: |
Download the SQL Server Express Installer:Anchor 3 3
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
Tip | ||
---|---|---|
| ||
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:Anchor 4 4
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
Installation guide:Anchor 5 5
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.
Figure 12: Feature Selection Window
Info | ||
---|---|---|
| ||
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.
Figure 13: Instance Configuration Window
Info | ||
---|---|---|
| ||
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.
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.
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.
Figure 16: Database Engine Configuration Window
- Authentication Mode, select Mixed Mode
- To specify the password for the SQL Server system administrator (sa) account: Enter password and confirm password.
- To specify SQL Server administrators: select Add Current User
Info | ||
---|---|---|
| ||
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.
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.
Figure 18: Feature Configuration Rules Window
Note | ||
---|---|---|
| ||
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:
Cause:
1. ReportServer.mdf
|
Step 14: The Installation Progress window will then be shown to indicate the installation progress. Wait for the installation process to finish.
Figure 20: Installation Progress Window
Step 15: Upon completing the installation, click Close to exit from the SQL Server Express 2014.
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)
...
Section | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||
|
.
...
.
Choices for confluence | ||
---|---|---|
|