Abinitio on unix to sqlserver on windows conn requirements

                    Abinitio on unix to sqlserver on windows conn requirements

This article details the steps required to connect from abinitio on linux ot sqlserver on windows where the sqlserver is kerberos enabled.

Step 1 :

Install 64 bit unix odbc drivers (unixODBC-2.3.0) 

Once installed check the below path

/apps/abinitio/abinitio-V3-3-2-1/misc/64/unixODBC-2.3.0/

Step 2:

Install mssqlodbc_V11

Once installed check the below path

/apps/sqlserver/client/native/11.0/lib/

Step 3 :

/etc/krb5.conf

Should contain

---------------------------------------------------------------

######################################################

# krb5.conf - Network Configuration File

######################################################

[libdefaults]

         default_realm = INTRANET.abc.COM

         default_tkt_enctypes = xxx-xx-xxx xx-xxxx

         default_tgs_enctypes = xxx-xx-xxx xx-xxxx

         dns_lookup_kdc = false

         dns_lookup_realm = false

[realms]

        INTRANET.abc.COM = {

                kdc = intranet.abc.com

                master_kdc = intranet.abc.com

                default_domain = INTRANET.abc.COM

        }

        INTRANET = {

                kdc = intranet.abc.com

                master_kdc = intranet.abc.com

                default_domain = intranet.abc.com

        }

[domain_realm]

                .intranet.abc.com = INTRANET.abc.COM

                intranet.abc.com = INTRANET.abc.COM

-------------------------------------------------------------------------------------

Step 4 :

Request has to be raised to make sqlservers Kerberos enabled (to authenticate cross platform clients) 

SPN have to be registered

Step 5:

Test the connection using sqlserver client (which gets installed as part of step 2)

Go to > cd /apps/sqlserver/client/native/11.0/bin/

Ex command :

sqlcmd -E -S servername,portno -d master -q "select name from sys.databases"

-E :implies trusted connection ( takes the credentials from keytab), no need of giving user name and password explicity

-S : server name

-d : database name

-q : query

unfortunately : if this does not work , plz change the /apps/sqlserver/client/native/11.0/krb5.conf as in the step 3


Author : Venkata Krishnan P