Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft SQL Server Connector
  3. Connections for Microsoft SQL Server
  4. Synchronization tasks with Microsoft SQL Server Connector
  5. Mappings and mapping tasks with Microsoft SQL Server Connector
  6. Replication tasks with Microsoft SQL Server
  7. Troubleshooting
  8. Data type reference

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Prepare for Kerberos authentication

Prepare for Kerberos authentication

You can use Kerberos authentication to connect to Microsoft SQL Server databases by placing the required configuration files on the Secure Agent machine. You can also use Kerberos authentication to connect to SSL-enabled Microsoft SQL Server databases.
When you configure Kerberos authentication to connect to Microsoft SQL Server, consider the following guidelines:
  • You can't use the Hosted Agent or serverless runtime environment.
  • Ensure that the Secure Agent and database server that you use are registered in the KDC server.
  • Consider the following guidelines when you use credential cache files:
    • On Linux, you can use the credential cache file of multiple Kerberos principal users within a connection without restarting the Data Integration Server. However, you can use only one Kerberos principal user within a mapping.
    • On Windows, you can use only one Kerberos principal user within a connection.

0 COMMENTS

We’d like to hear from you!