SQL 2014 Express

Recommended - This is a pre-configured installation of SQL for your server, designed to make installing SQL easier.  You will be able to click 'Next' through each screen. If you do not already have SQL installed on your server, please follow the steps below for this recommended install process.

If you are already using SQL Enterprise or Standard editions on the server, please locate the installation CD or files provided by Microsoft. Contact Microsoft if you require assistance installing this version for SQL server.

Click below to download the file from Support area in Synergy Cloud Services.

• SQL Express 2014 x64.zip

Unzip this file to your server and then proceed with the Install Instructions.

Launch SQL 2014 (64 bit) Express installer by running the file 'Setup_x64.bat'.

Find this in the file in the location you unzipped the downloaded files to from Synergy Cloud Services.

If User Account Control (UAC) is enabled on the server, click Yes to start the SQL setup process.

Click the image above to view the User Account Control prompt.

If a 'choose directory' prompt is shown it is recommended that you leave this to the default path, and click the 'OK' button.

Recommended to click OK on directory prompt.

Check the 'I accept the license terms' box to agree to the Microsoft license terms, then click Next.

Click the image above to view the License Terms screen.

If any product updates are available then they will be downloaded and installed during the initial setup process.

Click Next if a screen like below is shown. This is not shown in most cases.

Click the image above to view the Product Updates screen - example from the SQL 2012 installer.

Leave the settings as default, and click next.

Click the image above to view the Feature Selection screen.

Ensure the named instance is 'SYNERGY'. Click next.

Click the image above to view the Instance Configuration screen.

Click next.

Click the image above to view the Server Configuration screen.

Set a password for the SQL Instance.

• Recommended - The default password is 'Synergy2014’ (case sensitive).
• Optional - Enter a customised password.

Click the image above to view the Database Engine Configuration screen.

Click next if this window is shown, and the installation process will begin.

Click the image above to view the Error Reporting screen - sample from the SQL 2012 setup.

The install of SQL Express 2014 will begin. This process will take a few minutes to complete.

Click the image above to view the Installation Progress screen.

Check the results show that SQL has been installed successfully. If not please contact Synergy Support.

Click Close to exit the install wizard.

Click the image above to view the Installation Complete screen.