ubuntu client and microsoft sql server

mark mitchell <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAMci1LKX+Asn=1_U9_z2wSzbMu4KDFo517Efm91dzu-uoUPKGw@mail.gmail.com>
Hello,
I am trying to connect an Ubuntu client to Microsoft SQL Server. The server
has only Windows NT Authentication, with no possibility of SQL Server
authentication getting added (corporate policy - it's not going to happen).

I use 'tsql -S MYSERVER -U ...' with a well-defined
/etc/freetds/freetds.conf file entry:
[MYSERVER]
  dump file = /tmp/freetds.log
  debug flags = 0xffff
  host = ...
  port = 1433
  tds version = 7.0
  use ntlmv2 = yes

I always get '*Login failed for user. The user is not associated with a
trusted SQL Server connection*'. According to
http://decipherinfosys.wordpress.com/2008/11/14/the-user-is-not-associated-with-a-trusted-sql-server-connection/this
could be because the two machines do not have a trust relationship
with them.

>From my naive understanding of domain trusts from
http://www.samba.org/samba/docs/man/Samba-HOWTO-Collection/InterdomainTrusts.html,
setting up a trust relationship requires (quite reasonably) reconfiguring
both machines.

However, my first impression from the freetds documentation at
http://www.freetds.org/userguide/domains.htm was that freetds could handle
Windows NT authentication without any extra steps.

Some google searching found others with similar problems.

Perhaps the solution and/or domain trust requirements could be posted to
the freetds page cited above?

That being said, I am impressed with the software's ease of use, power and
documentation. And, I apologize if the answer is already available and I
have failed to find it.

Thanks
Mark Mitchell
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.