How to Connect to a Microsoft SQL Server Database that Uses Kerberos Authentication in Informatica 10.x

How to Connect to a Microsoft SQL Server Database that Uses Kerberos Authentication in Informatica 10.x

Prerequisites

Prerequisites

Before you configure the machine where the PowerCenter Integration Service runs for Kerberos authentication to Microsoft SQL Server database, perform the following tasks:
  1. Ensure that the Microsoft SQL Server database and the machine where the PowerCenter Integration Service runs are on the same Kerberos network. Verify that the Kerberos implementation of the network is based on Microsoft Active Directory.
  2. Verify with your database administrator that the Microsoft SQL Server database uses Kerberos authentication.
  3. Work with your system administrator to verify that the Microsoft SQL Server database user is a valid user in the Microsoft Active Directory domain.
  4. Install the SQL Server Native Client 2012 (SNAC) on the machine where the PowerCenter Integration Service runs.
  5. Install MIT Kerberos v5 client libraries on the machine where the PowerCenter Integration Service runs.