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

Step 2. Verify the Connection to the Microsoft SQL Server Database

Step 2. Verify the Connection to the Microsoft SQL Server Database

Verify and test the connection to the Microsoft SQL Server database on the machine where the PowerCenter Integration Service runs.
  1. To verify the connection to the Microsoft SQL Server database:
    • Install the SQL Server Management Studio (SSMS) on the machine where the PowerCenter Integration Service runs.
    • Install the SQLCMD command line utility to connect to the Microsoft SQL Server database.
  2. To test connection to the Microsoft SQL Server Kerberos instance:
    • If you have installed SSMS, you can then attempt to connect to the Microsoft SQL Server Kerberos instance from the SSMS.
    • If you have installed the SQLCMD command line utility, verify the connectivity to Microsoft SQL Server kerberized instance with the following command:
      C:\> SQLCMD -S <server_name>