To utilize a DirectSQL connection, you will need to follow the instructions in the link below to configure the local SQL Server to use an encrypted connection. Note that a .pfx-formatted certificate is required.
The steps below should be performed by our client’s IT. Support can assist with the application of the certificate, but we cannot acquire the certificate, nor make the relevant DNS entries on our client’s behalf.
1.) Configure SQL Server encryption
2.) Next, ensure that the SQL Server port (usually 1433) is accessible over the internet, and that a DNS record points to the on-premises SQL Server.
Next, ensure that the SQL Server port (usually 1433) is accessible over the internet, and that a DNS record points to the on-premises SQL Server.
Server=<sqlserverfqdn>;Database=<dbname>;UID=<user>;PWD=<password>;
Optional:
You can restrict access to the SQL server by whitelisting the following domains:
<subdomain>.mysquare9.com
capture-<subdomain>.mysquare9.com