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