These instructions are a guide for users who are installing Microsoft SQL Server Express 2014 on their local machine. When applying them to server installations you must consult with your IT department before installing the product to check you have the necessary rights and firewall configurations.
These guidelines are to be read in addition to the official instructions that can be found at http://www.microsoft.com/en-us/download/details.aspx?id=42299.
http://www.keynetix.com/staticdownloads/SQLEXPRWT_x64_ENU.zip
http://www.keynetix.com/staticdownloads/SQLEXPRWT_x86_ENU.zip
Note that you will need to install the version which corresponds to the Operating Systems Architecture of your server (32bit or 64bit).
The Installation Progress Screen will display and progression will run automatically. The installation process can be very resource intensive and may take a few minutes to complete.
You may also have to change the TCP/IP to enabled under the SQL Native Client 11.0 Configuration and the SQL Native Client 11.0 Configuration(32bit) - Client Protocols.
After changing the TCP/IP settings click on the SQL Server Services tab and select the SQL Server (SQLEXPRESS2014), right click and select Restart
Give the firewall rule the name "SQL Server Browser"