freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] NT Authentication Failing for an ODBC-Only Configuration - Revision - Limiting discussion
Date: Tue, 14 Jul 2009 08:49:19 -0400

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

Re: [freetds] NT Authentication Failing for an ODBC-Only Configuration - Revision - Limiting discussion, Gil Darves, 07/13/2009
- Re: [freetds] NT Authentication Failing for an ODBC-Only Configuration - Revision - Limiting discussion, Frediano Ziglio, 07/14/2009
- Re: [freetds] NT Authentication Failing for an ODBC-Only Configuration - Revision - Limiting discussion, James K. Lowden, 07/14/2009