[freetds] NT Authentication Failing for an ODBC-Only Configuration - Revision - Limiting discussion

James K. Lowden jklowden at freetds.org
Tue Jul 14 08:49:19 EDT 2009


Gil Darves wrote:
> 
> However, I am still curious why the bourne osql utility is failing.

> gild (dev) ~: osql -S MSSQLTestServer -U 'dm\gdarves' -P mypassword!
...
> "Server" found, not using freetds.conf
> FreeTDS servername is "10.7.22.22"
> 10.7.22.22 has address Host 22.22.7.10.in-addr.arpa not found:
> 3(NXDOMAIN)

(Your DNS is borked.  Not a problem for FreeTDS, though.) 

>  DSN: MSSQLTestServer
>  Server's hostname: 10.7.22.22
>                        Address: Host
>        22.22.7.10.in-addr.arpa: not found:: 3(NXDOMAIN)
>                         Driver: /usr/local/lib/libtdsodbc.so
> Attempting connection as dm\gdarves...
> 
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> 
> [37000][unixODBC][FreeTDS][SQL Server]Login failed. The login is from an
> untrusted domain and cannot be used with Windows authentication.

Did isql work and osql not?  It may be that osql needs to re-escape the
'\' when isql is invoked.  

--jkl


More information about the FreeTDS mailing list