Microsoft SQL Server Connector

Back Next

Setting environment variables

To use Kerberos authentication to connect to Microsoft SQL Server, you need to set the required environment variables on the Secure Agent machine.

Set the following environment variables:

setenv KRB5CCNAME <Absolute path and file name of the credentials cache file>

setenv KRB5_CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf

setenv JAASCONFIG <Absolute path of the JAAS config file>\<File name>.conf

After you set the environmental variables, you need to restart the Secure Agent.

Alternatively, you can add the environment variables when you create a Microsoft SQL Server connection.

To add the environment variables when you configure a connection and use Kerberos authentication, you need to add the KRB5_CONFIG, KRB5CCNAME, and JAASCONFIG properties in the

Metadata Advanced Connection Properties

field in a Microsoft SQL Server connection.

For example, add the properties in the following format:

KRB5_CONFIG=<Absolute path of the Kerberos configuration file>\krb5.conf;KRB5CCNAME=<Absolute path of the credential cache file>/<File name>;JAASCONFIG=<Absolute path of the JAAS config file>\<File name>.conf

Ensure that you separate each key-value pair with a semicolon.

Prepare for Kerberos authentication

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal