FreeTDS Development Group

[Pletyak Attila <pletyak.attila AT erba.hu>]

On Fri, 2002-04-05 at 18:17, Chad Enney wrote:
> Greetings,
> 
> I believe the problem you are having is because you are trying to do 
> domain authentication rather than SQL authentication. Freetds does not 
> yet support domain authentication - although there has been a few 
> messages flying around regarding some progress on this front.
> 
> Try adding a new user to SQL SErver that uses SQL authentication - it is 
> one of the selections on creating a new user - then remove the "try 
> domain login" and "nt domain" sections from the freetds.conf file.
> 
> If this doesn't resolve it for you, one of the more knowledgeable folks 
> around here probably need to look at it :)

Thanks for the reply. I've already tried to delete the NT domain
authentication, but it did not work either. But when I set the Try
server login to NO, it started to work, 3 of the 6 tests of "make check"
passed. 

What about with this long query and long response checks? These are
failed for me. How can I set up the system for these to work? Is it an
MSSQL specific question?

TIA,

Attila Pletyak

> 
> Attila Pletyak wrote:
> 
> >Hello,
> >
> >  I'm fiddling with freetds for some days now, and I'm not able to find
> >what the problem really is. Basically I would like to access the MSSQL
> >server running on a Win NT machine with freetds from my Linux box (Debian
> >Potato 2.2 with glibc 2.2.1).
> >
> >  I've configured freetds with --with-tdsver=7.0. I've tried to run the
> >"make check" command, and by default 5 of the 6 tests succeeds. This is
> >the JDBC connection in the default /usr/local/freetds/freetds.conf file.
> >
> >  Then I've entered our MSSQL database, with something like this:
> >[salamander]
> >        host = 192.168.0.6
> >        port = 1433
> >        tds version = 7.0
> >        try server login = yes
> >        try domain login = yes
> >        nt domain = Iaboteszt
> >        dump file = /tmp/freetds.log
> >        dump file append = yes
> >        debug level = 99
> >
> >  On the MSSQL side I've went into the enterprise manager program, and
> >created a login, and added it to the database which I need. From the
> >microsoft query program I can connect to the database with this
> >userid/passwd. I've also set that the NT authentication and SQL
> >authentication can both happen.
> >
> >  When I set this in the PWD file, and do make check on my linux box, I
> >get the answer of: "Not associated with a trusted SQL server". Can anybody
> >help me out why is this? To tell you the truth, I'm a beginner with MSSQL
> >server 7.0.
> >
> >  TIA,
> >
> >  Attila Pletyak
> >
> >---
> >You are currently subscribed to freetds as: [Chad.Enney AT noaa.gov]
> >To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [pletyak.attila AT erba.hu]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>