Skip to Content
0
Former Member
Jul 03, 2012 at 12:10 PM

IntegratedSecurity using MSSQL JDBC

665 Views

Hi all,

I am trying to connect from SAP PI 7.31 to a MS SQL database using IntegratedSecurity (Integrated Authentication) in order to avoid the need of update user and password in each communication channel. Has anyone done that?

I read this help from MS:

http://msdn.microsoft.com/en-us/library/ms378428.aspx

but I have doubts on where should I copy the file sqljdbc_auth.dll. Also is not clear for me if that is the only file I have to provide. JDBC driver is already deployed on the system and working fine when using normal user and password. I am using the option "IntegratedSecurity=true" on the connection string, but the channel is reporting an error with the following exception:

"com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication"

Many thanks in advance.

Nicolas