Preface
Introduction to Microsoft SQL Server Connector
- Microsoft SQL Server Connector assets
Connections for Microsoft SQL Server
- Prepare for authentication
  - Prepare for Kerberos authentication
    - Configuring Kerberos authentication
    - Setting environment variables
- Connect to Microsoft SQL Server
Mappings and mapping tasks with Microsoft SQL Server Connector
Troubleshooting
- Configuring the JDBC and ODBC drivers for Microsoft SQL Server Connector
Data type reference
- Microsoft SQL Server and transformation data types

Microsoft SQL Server Connector

Back Next

Configuring Kerberos authentication

Before you use Kerberos authentication to connect to Microsoft SQL Server on Linux or Windows, the organization administrator needs to perform the prerequisite tasks.

To configure the Java Authentication and Authorization Service configuration file (JAAS), perform the following tasks:

Create a JAAS configuration file on the Secure Agent machine.

Add the following entries to the JAAS configuration file:

JDBC_DRIVER_01 {
com.sun.security.auth.module.Krb5LoginModule required
useTicketCache=true;
};

Ensure that you specify each key-value pair on a separate line.

To configure the

krb5.conf

file, perform the following tasks:

Create a

krb5.conf

file on the Secure Agent machine.

Add the details of the Key Distribution Center (KDC) and admin server to the

krb5.conf

file in the following format:

[libdefaults]
default_realm = <Realm name>
forwardable = true
ticket_lifetime = 24h

[realms]
<REALM NAME> = {
kdc = <Location where KDC is installed> 
admin_server = <Location where KDC is installed>
}
[domain_realm]
<domain name or host name> = <Domain name or host name of Kerberos>
<domain name or host name> = <Domain name or host name of Kerberos>

Set the following environment variables on the Secure Agent machine.

For more information about the required environment variables, see Setting environment variables.

Restart the Secure Agent.

To generate the credential cache file on the Secure Agent machine and use Kerberos authentication to connect to Microsoft SQL Server, perform the following tasks:

On the Secure Agent machine, run the following command and specify the Microsoft SQL Server user name and realm name:

Kinit <user name>@<realm_name>

Optionally, when you connect to DB2 databases on Linux, you can run the following command to generate the credential cache file with the specified file name and directory on the Secure Agent machine:

Kinit -c <Directory and file name where you want to create the credential cache> <user name>@<realm_name>

Rename Saved Search

Table of Contents

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Configuring Kerberos authentication

Configuring Kerberos authentication