SQLExpress Installation

Installation of the local database, SQLExpress is only necessary for the stand alone version of Aviation Safety ++ where the program is installed on a single computer.  The network capable version is provided with separate database files for installation on the network server.

Create a System Restore Point

Before starting the installation procedure it is sound practice to create a ‘System Restore Point’ which will permit the roll back of the computer to a time prior to the installation of the SQLExpress.

The Windows operating system will create a system restore point automatically periodically by default. Windows also creates a system restore point, when it detects a major change happening to your system – like when you are installing Windows Updates, Drivers or at times Software.

These restore points represent a stored state of your computers system files and registry settings. If at any time you feel the need to undo some changes or if your Windows is not working properly, you can restore your system back to a prior ‘good’ restore point.

System Restore uses a feature called System Protection. It is a Windows feature that regularly creates and saves information about your computer’s system files, registry settings and previous versions of files. System Restore affects Windows system files, installed programs, registry settings, changes to scripts, batch files and other types of executable files – but does not affect personal files.

Stand Alone Installation

The database associated with Aviation Safety ++ (AS++) is not backward compatible with earlier versions of SQLExpress.  If AS++ is installed on a computer with an earlier version of SQLExpress it will have to be updated prior to running AS++.  For convenience Version 13.0.1722 is provided on the disk.  Versions later than 13.0.1722 may be installed instead of that supplied.  

For a new installation or to update an existing version double click on ‘SQLServer2016-SSEI-Expr.exe’ to start the process. If you receive a message stating that a later version of SQLExpress is available follow the instructions in the message.

You may need Administrator privileges to run the program, if so right click the file and select ‘Run as Administrator’ from the menu. When the install program starts click Install.

After clicking 'Install' check the 'I accept the licence terms and click 'Next'

When the install program loads select the ‘Custom Option’

A window will open asking for a location for the installation files.  Accept the default location of C:\SQLServer 2016 Media.  The files are then unpacked into the selected location and an installation window opens.  Select ‘New SQL Server standalone installation or add feature to an existing installation’.

Accept the terms and conditions and click ‘Next’.  The program starts to install. The installation process can take quite some time so ensure a laptop (if being used) is connected to external power.

Tick the box that states ‘Use Microsoft Update’ and click ‘Next’.

The next step shows the ‘Product Update’. page.  It is likely that the system cannot search for an update as this is a new installation and not an upgrade. Ignore any error messages and click Next. The program then runs the setup files.

The next step provides the ‘Install Rules’. Expect all rules to indicate ‘Passed’ with the possible exception of ‘Windows Firewall’ which may show ‘Warning’.  This warning will show if you are using a third party anti-virus and firewall protection software such as McAfee, or the Windows firewall is turned off. Ignore a Windows Firewall warning and click ‘Next’.

Next is the ‘Feature Selection’ page.  ­Do not select the ‘LocalDB’ option.  It should be unchecked in any case.  Accept the default file paths and click ‘Next’

The next page is Instance Configuration page.  Select the ‘Named instance’ radio button and note the name of the ‘InstanceID’. It will be ‘SQLEXPRESS’ unless there is another version of SQL Express installed.  

Note: It is important that you take a careful note of the InstanceID as this coupled with the computer name is how you connect to the SQLExpress Server.

Next up is the ‘Server Configuration’ page. Accept the defaults and click ‘Next’.  Do not tick the check box starting with ‘Grant Perform Volume … ‘. See Figure 9. Click ‘Next’.

Next step is the ‘Database Engine Configuration’. Ensure that ‘Windows authentication mode is selected on the Server Configuration Tab. Leave the defaults as they are on the other Tabs and click ‘Next’.

Next page is the ‘Reporting Services Configuration’ Ensure the ‘Install and configure’ radio button is selected and click ‘Next’.

The next step requires the installer to consent to the installation of ‘Microsoft R Open’.  Click the ‘Accept’ button. This enables the ‘Next’ button. Click ‘Next’.

The second last step in the install is the ‘Feature Configuration Rules.’  Accept the defaults and click ‘Next’.

Finally the ‘Installation Progress’ begins. This can take considerable time so do not cancel the installation if the program appears to be hanging.  Be patient and do not turn off the computer. When the installation progress is complete click the ‘Next’ button. A message is displayed indicating successful installation.