[freetds] Cannot connect to MSSQL named instance

Colin Adams colinpauladams at googlemail.com
Thu Jul 31 10:39:23 EDT 2008


2008/7/30 James K. Lowden <jklowden at freetds.org>:
> Colin Adams wrote:
>> >>> Doing an strace on tsql shows that it is send a datagram request to
>> >>> port 1434 as documented, but does not receive a reply.
>
>>> I did try telneting, but I find i can't
>>> telnet to any port on that machine (or from a windows machine where
>>> sql server management studio works fine with named instances).
>
>> Apprently there is no firewall between the two machines.
>
> One must ask why does telnet from the Win32 box not work?  Does ping?

My mistake. It does work on the port where the instance is running
(1435, as it happens). It doesn't work to 1434 (or 1433, for that
matter). But would telnet work on a UDP port anyway?

> It seems likely that either name resolution holds some surprise, or that
> the server is not answering on the expected ports.  AFAIK 1434 is not
> configurable; it's hard to see how it could be.
>
> TDSDUMP will show the 1434 interaction.

Which section of the user manual describes this (I can't find it yet).
What will it show that strace doesn't?



More information about the FreeTDS mailing list