Problem connecting to SQL Server from Linux with Cpanel hosting [SOLVED]

I was having trouble getting a Centos VPS to connect to SQL Server via tcpip. After fighting with FreeTds configurations for a week I finally figured out it was a networking problem. Connecting from my PC was ok but connections timed out when connecting between the shared hosts ip addresses.


The culprit was the CSF firewall on the Linux server which is apparently part of all Cpanel installions. I simply added the SQL Servers ip address to csf.ignore and csf.allow. You can find out more on how to handle this in the readme for CSF