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

Configure a Microsoft SQL Server Data Source for Windows

Configure a Microsoft SQL Server Data Source for Windows

  1. Open the Microsoft ODBC Administrator.
  2. Go to the system DSN tab.
  3. Click
    Add
    .
  4. Select
    DataDirect 7.1 New SQL Server Wire Protocol
    .
  5. Click
    Finish
    .
  6. Enter the data source name.
  7. Enter the host name.
    A host name is the machine where you installed the Microsoft SQL Server database.
  8. Enter the port number.
    Default is 1433.
  9. Enter the Microsoft SQL Server database name.
  10. On the security tab of DSN, set the following secure database parameters:
    Property
    Description
    Authentication Method
    Authentication method to access Microsoft SQL Server. Specify the authentication method to select 4- Kerberos.
    GSS Client Library
    An API for programs to access security services. Select native.