SQL Server Installation

This topic explains how to install and configure the SQL Server database software that is used to host the database which holds the 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 theMEDIAL server(s). After the installation,  you can migrate the database to the cluster as described in the topic SQL Cluster.

Install SQL Server

The following steps document installation of Microsoft SQL Express 2017. 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-us/download/details.aspx?id=55994.
  2. Open the package to begin the installation.  It will ask for a download location to download the installation files to. Change this if desired and click Next.
  3. On the Installation Type screen, select Custom.
  4. At the SQL Server Installation Center screen, click New SQL Server stand-alone installation or add features to an existing installation.

  5. Agree to the license terms and click Next.

  6. Check Use Microsoft Update to check for updates and click Next.

  7. Click Next on the Install Rules screen. Address any issues as necessary.
  8. The Feature Selection screen displays next.

    1. On this screen, check the following options:

      • Database Engine Services
      • Client Tools Backwards Compatibility (optional - useful for importing databases from older version of SQL)
    2. At the bottom of the features screen, change the installation directories as required and click Next.
  9. Name the SQL instance or leave it set to the default. Click Next.

  10. Click Next on the Server Configuration screen.

  11. On the Database Engine Configuration screen, select Mixed Mode and provide a password in the boxes. Click Next.

  12. Once the installation is complete, click Close to exit.

  13. Back on the SQL Server Installation Center screen, click on Install SQL Server Management Tools.
  14. On the download page that opens, click on Download SQL Server Management Studio to download it.
  15. When the file has downloaded run it to begin the install. Click Next on the Welcome screen.
  16. Let the install complete, and click Finish to close the window.

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 2017 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.