You are here: Setup > Installation > SQL Server Installation

SQL Server Installation

This topic explains how to install and configure the SQL Server database that holds MEDIAL content and user data. In a basic deployment, a database resides on the Windows Server that hosts the MEDIAL software. If you plan to use an SQL cluster in an advanced deployment, it is recommended to install MEDIAL using SQL Express on each MEDIAL machine. After the installations,  you can migrate to the cluster as described in the topic SQL Cluster.

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.

1. Click the Windows icon on the desktop—.

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.

 

Copyright © 2017 Streaming Ltd