	Product(s):	SELECTserver
	Version(s):	09.01.00.xx
	Environment:	Windows 7, Window Server 2008, Windows Server 2008 R2, Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows 10, Windows Server 2016
	Area:	Installation / Configuration
	Subarea:	SQL Installation

The following support solution provides step-by-step instructions for downloading and installing an instance of SQL Server 2016 Express. Please refer to the following support solution for the installation of earlier SQL Server versions.

Background

In addition to the SQL Server versions supported by earlier versions of SELECTserver, SELECTserver 09.01.00.xx adds support for SQL Server 2014 and 2016. Below are detailed instructions for installing an instance of SQL Server 2016 Express, a free edition provided by Microsoft. While the downloading method differs for Microsoft SQL Server 2014 Express, the instructions under the subheading titled "Installing SQL Server Express" are very similar.

Steps to Accomplish

Downloading SQL Server Express

If running Windows Server 2012 or later, please perform the following steps:

Download and execute the Microsoft SQL Server 2016 SP2 Express installer from Microsoft's website.
Choose the Custom option when prompted since SELECTserver utilizes features not enabled by default in the Basic installation.
The program will download the installer to the specified location.

Installing SQL Server Express

Once the installer appears, proceed through the following steps:

Choose the "New SQL Server stand-alone installation" option highlighted in the screenshot.
Accept the licensing terms, and click the Next button.
To obtain the latest updates from Microsoft, turn on Microsoft Update.
If any updates are found, apply them.
Once any updates have been applied and potential problems have been investigated, click the Next button.
On the following screen, click the Next button to proceed with default selections unless using alternate installation locations.
In most cases, the default instance name will be sufficient. For additional clarity, the instance can optionally be named SELECTserver. Click the Next button to proceed.
Default Service Account settings will be sufficient if SQL Server Express is being installed on the same machine where SELECTserver will reside. Click the Next button.
Choose the "Mixed Mode" radio button in the Authentication Mode section. Also enter a strong password containing uppercase and lowercase characters and either numbers or symbols. Click the Next button to continue. The installer will display an error if the password is not strong enough or if the two password fields do not match.
The installer may prompt for a restart of the machine if any files could not be updated immediately. If the below message appears, restart the server when possible following the installation.
An installation summary will appear once SQL Server 2016 Expresss has been installed. Click the Close button, and close the SQL Server Installation Center window.