[freetds] Cannot connect to MSSQL named instance

Colin Adams colinpauladams at googlemail.com
Wed Jul 30 14:01:25 EDT 2008


Apprently there is no firewall between the two machines.

2008/7/30 Colin Adams <colinpauladams at googlemail.com>:
> That's a good question, to which the answer is I don't know (I am not
> a systems administrator here). 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).
>
> So I'll ask our firewall adminstrators.
>
> 2008/7/30 Bob Hetzel <beh at case.edu>:
>> Does the firewall on the SQL Server allow connections on port 1434 from
>> the machine with TDS on it?
>>
>>    Bob
>>
>> Colin Adams wrote:
>>> Hello,
>>>
>>> I'm using FreeTDS 0.82 to try to connect to MSSQL databases from Linux
>>> with TDS version 8.0 .
>>>
>>> This works fine if I specify the port number, but not if I specify the
>>> instance name.
>>>
>>> Doing an strace on tsql shows that it is send a datagram request to
>>> port 1434 as documented, but does not receive a reply.
>>>
>>> My database adminstrator thinks this must be some kind of problem with
>>> the MSSQL browser service, but does not know the answer yet. I was
>>> wandering if any orher FreeTDS users had encountered this problem.
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS at lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>



More information about the FreeTDS mailing list