Which ports are required to connect to SQL Server from tiny_tds?

Question

There is not route between the web server (CentOS, 192.168.10.100) and the SQL Server (192.168.12.200).

I have installed tiny_tds on the web server. Which network ports are required to add to the routes in order for tiny_tds to read/write SQL Server data?

Answer 1

The default SQL Server port is 1433, and client ports are assigned a random value between 1024 and 5000.

http://support.microsoft.com/kb/287932

tiny_tds follows the default ports.