Install and Configure SQL

After enabling .NET and IIS on your server, you will need to install SQL. This is an optional step that can be skipped if you have a separate SQL instance that you will be using for your Recast Management Server Database.

NOTE: SQLExpress is used in these instructions for demonstration purposes. It can serve as a temporary database at the Proof-Of-Concept stage, but its limited size will not support web dashboard and dashboard trends in a Recast Management Server deployment. The steps for installing and configuring a licensed version of SQL will be similar.

To install SQLExpress:

1. Download SQLExpress from https://www.microsoft.com/en-us/Download/details.aspx?id=101064. When you begin installation, you will be presented with the installation type screen. Select Basic installation.

2. Accept the SQL Server License Terms. 

   

3. Choose the install location and click Install

4. After installation completes, it is recommended that you install the SQL Server Management Studio (SSMS). The download is also located here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15.

 

To change the network configuration:

1. Open SQL Server Configuration Manager.

2. Select SQL Server Network Configuration and double-click on Protocols for SQL Express.

3. Select TCP/IP.

 

4. Change Enabled to 'Yes'. 

5. Select  the IP Addresses tab and scroll down to the IPAll section.  

6. Add port 1433 as the TCP Port (this is the standard port for SQL)  

7. You will need to stop and restart the service for changes to take effect. Return to the front page of the SQL Server Configuration Manager and right-click on the running SQL server instance. Select Restart

You are now ready to install the Recast Management Server