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

IntegratedSecurity using MSSQL JDBC


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:

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:

" This driver is not configured for integrated authentication"

Many thanks in advance.