Skip to Content.
Sympa Menu

freetds - Re: [freetds] Cannot connect to MSSQL named instance

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Colin Adams" <colinpauladams AT googlemail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Cannot connect to MSSQL named instance
  • Date: Wed, 30 Jul 2008 16:18:25 +0100

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
>




Archive powered by MHonArc 2.6.24.

Top of Page