Skip to Content.
Sympa Menu

freetds - Re: [freetds] tds7_get_instance_port timed out

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Daniel Fazekas <fdsubs AT t-online.hu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] tds7_get_instance_port timed out
  • Date: Sat, 20 Mar 2010 17:47:10 +0100

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.





Archive powered by MHonArc 2.6.24.

Top of Page