FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On Fri, 1 Aug 2003 16:05:40 -0500, "Chris Hettinger"
<chettinger AT encompas.com> wrote:
> Thanks for the reply.
> Inserted that line, but it didn't change the outcome of the tsql test.

Sorry, let's try this then:
[ENCPPP]
        host = encppp.encompass.enc
         port = 1433
         tds version = 7.0
         try domain login = yes
         try server login = no

We have to explicitly say which is true and which is false.  Otherwise,
I'm not sure what happens.  

That should do it.   Famous last words, I know.  

Note to list:  Does anyone want to test this, and preferably fix it?  A
server may be configured to accept both kinds of logins.  It would be nice
to try both in turn before reporting a failure, because per-connection
there's no way to specify the type.  

--jkl

> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: Friday, August 01, 2003 3:54 PM
> > From: Chris Hettinger [mailto:chettinger AT encompas.com]
> > Sent: August 1, 2003 4:42 PM
> > 
> > I am trying to communicate with a MS SQL 2000 DB on a Win2003 
> > server from my client (Mandrake Linux 9.1, glibc23).
> > 
> > freetds.conf entry:
> > [ENCPPP]
> >         host = encppp.encompass.enc
> >         port = 1433
> >         tds version = 7.0
>          try domain login = yes
>                              ^^^
> 
> Add the above line.  That *should* be all you need with FreeTDS 0.61.  
> 
> The feature hasn't been widely exercised, but we don't have any known
> failures.  
> 
> HTH.
> 
> --jkl
> 
> > To test the connection I used tsql and received:
> > 
> > # tsql -S encppp.encompass.enc -U chettinger
> > Msg 18452, Level 14, State 1, Server , Line 0
> > Login failed for user 'chettinger'. Reason: Not associated 
> > with a trusted SQL Server connection.
> > Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> > Login incorrect.
> -----------------------------------------
> The information contained in this transmission may contain privileged
> and confidential information and is intended only for the use of the
> person(s) named above. If you are not the intended recipient, or an
> employee or agent responsible for delivering this message to the
> intended recipient, any review, dissemination, distribution or
> duplication of this communication is strictly prohibited. If you are not
> the intended recipient, please contact the sender immediately by reply
> e-mail and destroy all copies of the original message. Please note that
> we do not accept account orders and/or instructions by e-mail, and
> therefore will not be responsible for carrying out such orders and/or
> instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 
> CONFIDENTIALITY NOTICE:  This communication, including any attachment,
> may contain confidential information and is intended only for the
> individual or entity to whom it is addressed.  Any review,
> dissemination, or copying of this communication by anyone other than the
> intended recipient is strictly prohibited.  If you are not the intended
> recipient, please contact the sender by reply email, delete and destroy
> all copies of the original message.'
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds