Windows: Build and configure FreeTDS for Guardium

FreeTDS allows Unix/Linux machines to connect to an SQL Server on Windows machines.

Before you begin

Verify these requirements for using FreeTDS successfully with Guardium®, such that all information (DB_USER, SOURCE_PROGRAM, etc.) is included in the Guardium reports.
  • FreeTDS V1.00.111 or later
  • OpenSSL Support in FreeTDS
  • Kerberos Support in FreeTDS
  • TDS Version Auto in FreeTDS
  • Domain Joined Linux System
  • Domain Joined SQL Server Windows System Setup for Kerberos Logins

About this task

To determine what version of FreeTDS you have and what type of support has been compiled into the program, execute the command tsql -C to see the FreeTDS characteristics on your machine. You should see something like:compile time settings

Procedure

  1. Download a suitable C/C++ compiler package and an OpenSSL package. See instructions in the users guide www.freetds.org for more details and for the download of the latest FreeTDS package.
  2. Unpack the tarball and then set your folder to the FreeTDS kit root folder. Enter the following commands: 
    $ ./configure –enable-krb5 –with-openssl
$ make
$ su root
Password
$ make install
  3. Test that the SQL Server logs in to a system named “node” and determine whether Kerberos is being used. Enter the commands: 
    $ tsql -S node
1>	select auth_scheme from sys.dm_exec_connections where session_id = @@SPID
2>	go
auth_scheme
KERBEROS
(1 row affected)