[unixODBC-support] isql and FreeTDS vs NTLM

Nick Gorham nick.gorham at easysoft.com
Tue Jul 4 09:21:41 BST 2006

Spörlein Ulrich wrote:

>I set up unixODBC 2.2.11 and FreeTDS 0.63 on a FreeBSD 6.1 machine and I'd like to access an MS SQL server. This works fine when using 'tsql' and my username of 'DOMAIN\u.spoerlein'. Yes, I need to authenticate with my domain login.
>When using the isql tool, it connects to the MS SQL server (as seen by tcpdump) and sends the login name and password in clear text (tsql uses NTLMSSP). If isql is using the TDS driver, why isn't it using NTLM as well? Anyway, 'isql' is not working, as the MS SQL server will terminate the connection immediately after receiving the login credentials.
>Ethereal decodes the tsql packets as 'TDS7/8 Login Packet, NTLMSSP_NEGOTIATE' whereas the isql packets are simply labelled 'Login Packet'.
>Any hints?
Well, firstly I would suggest, that isql is working fine. I would guess 
the problem lies in the configuration of the driver, I would ask the 
freetds folk.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list