[unixODBC-support] isql and FreeTDS vs NTLM
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'.
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
More information about the unixODBC-support