Skip to Content.
Sympa Menu

freetds - RE: [freetds] Domain Login Support, connecting to MSSQL issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Domain Login Support, connecting to MSSQL issue
  • Date: Sat, 02 Aug 2003 11:53:58 -0000


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






Archive powered by MHonArc 2.6.24.

Top of Page