FreeTDS Development Group

["Chris Hettinger" <chettinger AT encompas.com>]

Thanks for the further replies guys.

I added the line : try server login = no to my freetds.conf

Also tried these tsql commands:

# tsql -S ENCPPP -U chettinger
Password:
Msg 10019, Level 9, State 0, Server OpenClient, Line 0
Server ENCPPP not found!
There was a problem connecting to the server

# tsql -S ENCPPP -U encompass.enc\chettinger
Password:
Msg 10019, Level 9, State 0, Server OpenClient, Line 0
Server ENCPPP not found!
There was a problem connecting to the server

# tsql -S encppp.encompass.enc -U chettinger
Password:
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.
There was a problem connecting to the server








-----Original Message-----
From: James K. Lowden [mailto:jklowden AT schemamania.org]
Sent: Saturday, August 02, 2003 10:15 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Domain Login Support, connecting to MSSQL issue


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
_______________________________________________
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.'