Skip to Content.
Sympa Menu

freetds - Re: MSSQL: Not associated with a trusted SQL Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chad Enney" <Chad.Enney AT noaa.gov>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: MSSQL: Not associated with a trusted SQL Server
  • Date: Fri, 05 Apr 2002 09:17:21 -0700


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

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







Archive powered by MHonArc 2.6.24.

Top of Page