Installation guide
mxODBC - Python ODBC Database Interface
string. Please see this article for details: Service Principal Name (SPN) Support in
Client Connections
MS SQL Server Native Client for Linux
Please see this article for details on how to setup the driver to use Kerberos
authentication: Using Integrated Authentication
Also see the EasySoft documentation below for some added details around the
setup of Kerberos authentication on Linux.
EasySoft SQL Server Driver for Linux
Please see the following page for details on how this driver is setup: Securing
Access to SQL Server from Linux with Kerberos
FreeTDS ODBC Driver for Linux
The FreeTDS ODBC driver can be built against the Kerberos libraries and provides
the same
Trusted_Connection keyword connection parameter as the MS SQL
Server Native Client. Provided you have Kerberos working on the system, you
simply have to replace the "
UID=…;PWD=…" part of your connection string with
"
Trusted_Connection=yes" in order to use Kerberos authentication.
Kerberos on Linux
All of the above have some information about the setup of Kerberos on Linux. This
book chapter has all the information you need to complete the setup:
http://commons.oreilly.com/wiki/index.php/Linux_in_a_Windows_World/Centralize
d_Authentication_Tools/Kerberos_Configuration_and_Use
If you want to use an Active Directory, you will additionally have to use Samba to
integrate into the AD, hook winbind into PAM and have pam_winbind use
Kerberos authentication:
http://wiki.samba.org/index.php/Samba_&_Active_Directory
A user can then log in and authenticate against the AD and the Kerberos server
will provide the necessary credentials to the ODBC driver.
Other Common Problems and Solutions
A general description of the problems you might experience when accessing the
MS SQL Server using ODBC is described in the article Using ODBC with Microsoft
SQL Server. Even though it's dated September 1997 it provides some insights into
the design and workings of the MS SQL ODBC driver.
42