FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

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

Try 
  tsql -S ENCPPP -U chettinger
or
  tsql -S ENCPPP -U 'yourdomain\chettinger'

You have to use freetds.conf entry if you want tsql read it...

freddy77