Introduction
This document provides a complete guide for setting up Hybrid OSTO in a local (on-premise) environment. It covers prerequisites, installation steps for each component, and basic troubleshooting guidance, drawing on the related installer documentation for OSTO, SQL Connect and the OSTO Licensing App.
Prerequisites
Before starting the installation, confirm that the following requirements are in place:
Requirement | Details |
Outbound network access | Allow outbound communication over port 1433 and the allocated SQL Connect port (unique per customer). |
OSTO Licensing App port | Allow outbound communication over port 18555. |
FTP access | Use an FTP client (e.g. FileZilla) to download the required files from customerftps.accessnet.co.uk. Credentials are shared via a separate, secure channel. |
Licensing URL | Whitelist https://api.erp.accessacloud.com/osto-licensing in your firewall settings. |
.NET Runtime 6.0.22 | Required for the OSTO Licensing App. Included with the installer, which will prompt for installation if not already present. |
Microsoft Visual C++ 2012 Redistributables | Required for OSTO and checked automatically during installation. Included with the OSTO installer. |
Deliverables
Files to Download
Download the following files from the FTP server before beginning the installation:
Item | File Name |
OSTO Installer | OnScreenTakeOffInstallationOnPremise.exe |
OSTO Installer Documentation | OSTO Installer - Documentation.docx |
OSTO Licensing App Installer | OSTO Licensing App.exe |
OSTO Licensing App Documentation | OSTO Proxy App - Documentation.docx |
SQL Connect Client Installer | MyDesk_SQL_Connect_Client.exe |
SQL Connect Certificate | *.mydesksqlconnect.accesshosting.co.uk.crt |
SQL Connect Key | *.mydesksqlconnect.accesshosting.co.uk.key |
Troubleshooting SQL Connect | Troubleshooting SQL Connect.docx |
Troubleshooting Licensing | Troubleshooting Licensing.docx |
Port.txt | Contains the port used by the OSTO Licensing App |
DatabaseName | Contains the database name required in the OSTO installer |
Schema
The diagram below illustrates the overall architecture of the Hybrid OSTO setup.
Installation Steps
The installation is completed in three stages: installing SQL Connect, installing the OSTO Licensing Application, and installing OSTO itself. Complete each stage in order.
Install SQL Connect
Run the installer file MyDesk_SQL_Connect_Client.exe. The installation wizard
Proceed through the installation wizard.
Select the installation location.
Select the KEY file provided inside the installer package.
Enter port 1433 as the port to listen on.
Enter the allocated port number found inside the Port.txt file.
Select the CRT file provided inside the installer package.
Finish the installation.
Install the OSTO Licensing Application
Refer to the OSTO Licensing App documentation for full installation instructions.
📌Note: Any existing legacy licensing system must be removed before installing the new application. Search the machine for “Dimtronix Licensing Server” or “Exactal Licensing Server” and uninstall it before proceeding.
Wizard installation steps
Double-click the installer file OSTO Licensing App.exe.
The setup checks for the required .NET Runtime 6.0.22 prerequisite.
Proceed with installation of the prerequisite.
Select Install, then Close once the installation completes successfully.
The licensing installer opens on the Subscription Key page.
Enter the required subscription key when prompted.
Choose the installation location.
Select Install.
Once installation completes, the Windows service is created and started automatically.
Install OSTO
Double-click the installer file OnScreenTakeOffInstallationOnPremise.exe.
The setup checks for the required Visual C++ Redistributable 2012 prerequisite.
Proceed with installation of the prerequisite.
Check the “I agree” checkbox, select Install, then Close once the installation completes successfully.
Choose the installation location.
Select Next.
DO NOT close the installer at this stage — the following steps must be completed before the installation can be finalised.
The database name can be found in the DatabaseName.txt file.
The SQL credentials can be retrieved from within ConQuest Q-Series:
Open ConQuest.
Go to Options → On-Screen TakeOff.
Select “On another Server or user's PC”.
On first use, it may take up to 30 minutes for the credentials to become available. While “On another Server or user's PC” is selected, the button to open On-Screen Take Off is temporarily removed from ConQuest.
To restore the button, select “Hosted with ConQuest” and restart the application
Press and hold the SQL password field to reveal the password (temporary behaviour).
Enter the information collected in the previous steps into the corresponding fields in the installer.
Select Next.
Select Next.
Select Install.
Once installation completes, On-Screen Take Off can be started.
Troubleshooting
For further guidance, refer to the dedicated troubleshooting documentation for each component: the OSTO installer, SQL Connect, and the OSTO Licensing App.