FreeTDS Development Group

["Magician7 usa" <magician7usa AT hotmail.com>]

Check out this link....  It may help.

http://www.freetds.org/faq.html#connectionrefused


> From: Chris parent <kireol AT yahoo.com>
> Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] connecting Linux to MS SQL Server
> Date: Wed, 2 Feb 2005 17:04:36 -0800 (PST)
>
> Hello. First time poster here.  The help file for
> posting here is missing from the freetds webpage, so I
> apologize if I am doing something incorrect here.  I'm
> using freetds-0.62.4
>
> I am attempting to connect to a MS SQL Server DB that
> resides on a Windows Server 2003 box from a Linux box
> and PHP.  The SQL Server is in "Windows NT domain
> authentication" Mode, not SQL login.
>
> I've successfully connected to the database from other
> programs and other computers, so I'm confident that
> that part is working as expected.
>
> I see that newer versions of FreeTDS (thank god for
> all of the devs work on this fine package) support
> Windows NT Auth Logins:
> http://www.freetds.org/userguide/domains.htm
>
> I've follow the sample test to see if it will connect
> to my database with:  tsql -S 192.168.111.2 -U
> 'MYDOMAIN\myNTLoginName' -P mypassword
>
> the response is locale is
>
> "en_US.UTF-8"
> locale charset is "UTF-8"
> src/tds/login.c: tds_connect: 192.168.111.2:4000:
> Connection refused
> Msg 20009, Level 9, State 0, Server OpenClient, Line 0
> Server is unavailable or does not exist.
>
> My thinking is that under NT SQL Server settings, the
> "use a set IP" is not checked.  I reall would prefer
> not to change anything on the NT box as it may break
> one of the many applications that run connect and
> already use this DB.
>
> Is there any way to still use freeTDS and get this to
> work?
>
> Many thanks,
> -=Kireol
>
>
>
> __________________________________
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
> http://promotions.yahoo.com/new_mail
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds