freddy77 at gmail.com
Fri May 8 09:10:03 EDT 2009
2009/5/7 Gennady Vayl <vaylg at hotmail.com>:
> Thanks for the reply.
> I think I have the proper tds version now and iconv is off...
> Compile-time settings (established with the "configure" script)
> Version: freetds v0.82
> freetds.conf directory: /usr/local/etc
> MS db-lib source compatibility: no
> Sybase binary compatibility: no
> Thread safety: yes
> iconv library: no
> TDS version: 8.0
> iODBC: no
> unixodbc: no
> I'm getting a new error:
> Login failed for user ''. The user is not associated with a trusted SQL Server connection.
> Msg 20002, Level 9, State -1, Server OpenClient, Line -1
> Adaptive Server connection failed
> There was a problem connecting to the server
> I read on the users guide that I need: The setting should be "Send LM & NTLM responses".
> I can't set this since our IT doesn't allow this. Is there a workaround?
I don't remember if 0.82 support ntlm2 but updated version surely
does. Get update patch at freetds.sf.net (official patched 0.82 or
update 0.82 with the post 0.82 patch).
You have to use domain\user syntax in tsql, something like
tsql -S myserver -U 'domain\username'
More information about the FreeTDS