FreeTDS + SQL Server + NTLM v2?

Samuel Bayer <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi all -

I'm a new user of FreeTDS. I'm using a very recent snapshot 
(freetds-0.83.dev.20101105) because the comments on this list implied 
that these recent snapshots contain support for NTLM v2, and in fact 
default to NTLM v2 when presented with a domain login. I have an SQL 
Server instance, which I don't manage, which is configured to accept 
NTLM v2 only. I attempt to contact it from my Mac (running Snow Leopard, 
not a member of the Windows domain) via a DSN-less connection as 
follows, and get the following error:

------------------------------------

$ TDSVER=8.0 tsql -H <server> -p 1433 -U '<domain>\sam'
Password:
locale is "C"
locale charset is "US-ASCII"
using default charset "ISO-8859-1"
Msg 18452 (severity 14, state 1) from DEPOTSQL Line 1:
	"Login failed. The login is from an untrusted domain and cannot be used 
with Windows authentication."
Error 20002 (severity 9):
	Adaptive Server connection failed
There was a problem connecting to the server

-------------------------------------

where <server> is the FQDN of my server, and <domain> is the domain  the 
SQL Server is a member of, which is a domain in which the user "sam" 
(which is me) has an account.

Now, I know I can contact this DB; I've used the jTDS JDBC driver to 
contact this same database from my Mac using the following DB connection 
string:

jdbc:jtds:sqlserver://<server>:1433;DatabaseName=<db>;domain=<domain>;useNTLMv2=true

If I omit "useNTLMv2=true", I get exactly the same error I'm getting 
with the tsql command above.

If FreeTDS defaults to NTLM v2, why I am getting this error with tsql?

Thanks to all in advance -

Sam Bayer
The MITRE Corporation
[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.