Cablecast 7.1 requires SQL server 2014 or newer in order to run the installer correctly.

Steps to update SQL server

1. Backup Frontdoor/Cablecast/Carousel/CablecastCG databases.
2. Uninstall SQL server 2005/2008 from the server as well as SQL Server Management Studio(You shouldn't need to uninstall other components or touch any SQL folders).
3. Download the file
   1. For SQL 2019:
      - https://www.microsoft.com/en-us/Download/details.aspx?id=101064. Click Download, then select "Express 64BIT\SQLEXPR_x64_ENU.exe"/
   2. Note: If updating SQL on an old host to 2015 or VIO server, then use: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver16
4. Reboot the Computer.
5. When back into computer, run the downloaded file.

Installing SQL Update:
When exe file starts, click on Custom this will download the files needed



The Installation Center page will pop up after successful download.

Choose option: New SQL Server stand-alone installation

Accept the TOS, then click next and check the checkbox for running Microsoft updates during the update.


Click next until the Feature Selection and make sure that ONLY Database Engine Services is checked. Then click next again.

Scroll down and keep Shared Features as well.

Click Next.

Instance Configuration.
MUST USE Default Instance
Make sure no other instances are running in the box below. If there are, you will need to go back to step 2 and verify that previous instances have been completely removed.

Leave settings for Windows Authentication Mode

This allows for the user in the box below to be made the admin. If the user account you're seeking is not highlighted in the box below you can add users to be part of the admin group for SQL by clicking on the Add button.
The current user will be added to the admin for SQL. This is also a good step to pause at and verify that you're using the correct user.

Click Next for the installation to run. The server might have to restart once in the process.
After installation, Open the newer SQL server management studio and login to the updated SQL server.

Right click the Database dropdown and select Restore Database and choose each backup to restore that were created in Step 1.

SQL Server is now updated and you should be OK to run the Cablecast 7 Installer