MSSQL: Not associated with a trusted SQL Server
Attila Pletyak
pletyak.attila at erba.hu
Fri Apr 5 02:45:21 EST 2002
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
More information about the FreeTDS
mailing list