Re: tds7_get_instance_port timed out

On Mar 20, 2010, at 17:28, Gregor at HostGIS wrote:

> [ec2test]
>         host = ec2-174-129-135-45.compute-1.amazonaws.com
>         port = 1433
>         tds version = 8.0
>         instance = SQLSERVER
> (net.c:836):tds7_get_instance_port(174.129.135.45, SQLSERVER)
> (net.c:905):tds7_get_instance_port: timed out on try 0 of 16
> Can you explain what tds7_get_instance_port() does exactly, or how I'd  trace out what TCP port it's trying to connect? Port 1433 is open but other ports are not, so if it's trying to connect to some other port for this specific instance it may be blocked there.

Not TCP, the automatic port discovery for named instances uses UDP port 1434.
Considering you are already sure the server is listening on TCP 1433, you have no need for that or specifying the instance name. 
Just remove the "instance=" line.