SQL Server Installation
Install SQL Server
The following steps document installation of Microsoft SQL Express 2014. Other versions of MSSQL are supported for use, but verify alternate choices with MEDIAL support. Databases from vendors other than Microsoft are not supported.
To install SQL Server:
1. Download the version of SQL Server you intend to use. The free Microsoft SQL Express with Tools is available at https://www.microsoft.com/en-gb/download/details.aspx.
2. Open the package to begin the installation.
3. At the SQL Server Installation Center screen, click New SQL Server stand-alone installation or add features to an existing installation.
4. Agree to the license terms and click Next.
5. Check Use Microsoft Update to check for updates and click Next.
6. The Feature Selection screen displays next.
a. On this screen, check the following options:
Database Engine Services
Client Tools Backwards Compatibility (useful for importing databases from older version of SQL)
Management Tools – Complete
b. At the bottom of the features screen, change the installation directories as required and click Next.
7. Name the SQL instance or leave it set to the default. Click Next.
8. Click Next on the Server Configuration screen.
9. On the Database Engine Configuration screen, select Mixed Mode and provide a password in the boxes. Click Next.
10. Once the installation is complete, click Close to exit.
Configure SQL Connections
Once SQL Server has been installed, you need to configure it to allow connections from MEDIAL.
2. Type SQL Configuration.
3. Choose SQL Server 2014 Configuration Manager when it appears.
4. When the configuration manager opens, expand SQL Server Network Configuration and choose Protocols for SQLEXPRESS (or the name of the SQL instance if not the default). Double-click on TCP/IP on the right side of the window.
5. In the box that appears, change the status to enabled by selecting Yes in the drop-down box. Then click the IP Addresses tab.
6. Locate the IP addresses that the MEDIAL websites use and change the Enabled value to Yes using the drop-down box. Scroll to the bottom of the window.
7. The last value is the port that will be used to accept incoming connections. Use the standard SQL port value 1433. Click OK to save the changes and close the window.
8. A warning advises that the changes will not take effect until the SQL Server service is restarted. Click OK.
9. In SQL Server Configuration Manager, click SQL Server Services.
10. In the right-hand pane, right-click the SQL Server server and choose Restart.
11. Close SQL Server Configuration Manager.