How to Install iConnect Studio

Requirements:

• Computer Running Windows 7, 10 or Server 2008 and Newer
• Dual core or grater CPU
• 4 GB of RAM
• 80 GB or greater Hard Drive
• .NET Framework 3.5
• .NET Framework 4.5
• SQL Server Express
• SQL Server Management Studio

Recommendations:

• Static IP Address (Can be obtained from ISP)

Notes:

• Windows 10 is not compatible with our TCA modem and will only work with iLink units.
• The latest version of our software only support iLink and TeLink 700 units.

1. Install Prerequisites

1. Install .net 3.5 from: https://www.microsoft.com/en-us/download/details.aspx?id=21

2. Install .net 4.5 from: https://www.microsoft.com/en-us/download/details.aspx?id=30653

3. Install DirectX from: https://www.microsoft.com/en-us/Download/confirmation.aspx?id=3
4. Install SQL Server Management Studio from: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
5. SQL Server Express
   1. Windows 7 - Download and install SQL Server from Microsoft from: https://download.microsoft.com/download/4/1/A/41AD6EDE-9794-44E3-B3D5-A1AF62CD7A6F/sql16_sp2_dlc/en-us/SQLEXPRADV_x64_ENU.exe
   2. Windows 10 - Follow: https://learnsql.com/blog/how-to-install-sql-server-2017-windows

      • Set the SA password to: sauser (step 13) - optional

2. Configure SQL Server Configuration Manager to allow TCP and Enable SQL Server Browser

1. Start SQL Server Configuration Manager by searching for it and starting or edit in local Computer Management under MMC
2. Open SQL Native Client Configuration - Open Client Protocols - Verify TCP/IP Says Enabled - If it does not right click on TCP/IP and press enable
3. Open SQL Server Network Configuration - Open Protocols - Verify TCP/IP Says Enabled - If it does not right click on TCP/IP and press enable
4. Open SQL Native Client Configuration (32bit) - Open Client Protocols - Verify TCP/IP Says Enabled - If it does not right click on TCP/IP and press enable
5. Open SQL Server Services - Right Click on SQL Server Browser - Go to Service Tab - Click on start mode and switch to automatic - Click Apply
6. Right Click on SQL Server - Click Restart
7. Right Click on SQL Server Browser - Click Start

3. Import NTL Studio Database into SQL Server

1. New Database
   1. Follow the steps from step 4(Install iConnect Studio), sub-step 4
2. Restore Existing Database
   1. Follow the "How to Restore Your SQL Database" section from: Backing up/Restoring Your NTL Studio Database

4. Install iConnect Studio

1. Download iConnect Studio from: iConnect-Installer-2017-78.zip
2. Unzip and run "iConnect Studio Installer.exe"
3. Start iConnect Studio - It will give you an error the first time because it is not connected to any DB
4. Select the SQL Server you just installed along with the database name - if it does not show up most likely there is a problem with the SQL Server setup
   • If you are starting with a fresh database, Click 'Generate Database' then open the "SQL Database Name" drop down and look for 'NTLStudioDatabase'
5. Press Ok when the settings are correct and Restart NTL Studio

5. Change Router and Firewall Settings (Required For Connect-Backs)

1. Forward port 3002 on your router to the IP address of your NTL Studio computer on port 3002 (Can be done under port forwarding on most routers)
2. Permit TCP Port 3002 on the Computers Firewall
3. Add a Static Reservation on the router for your NTL Studio Computers IP Address

6. Verify iConnect Studio works by connecting a unit

1. Open iConnect Studio Management & Distribution - you shouldn't get any errors when opening
2. Try connecting directly to a unit and doing a connect back to verify that everything works - in order for a connect back to work you have to have distribution open as well
3. If you have any problems try troubleshooting with the articles in this knowledge base