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

Back Next

Configure a Microsoft SQL Server Data Source for Windows

Open the Microsoft ODBC Administrator.

Go to the system DSN tab.

Click

Add

Select

DataDirect 7.1 New SQL Server Wire Protocol

Click

Finish

Enter the data source name.

Enter the host name.

A host name is the machine where you installed the Microsoft SQL Server database.

Enter the port number.

Default is 1433.

Enter the Microsoft SQL Server database name.

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.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.