windows Authentication for MS SQL server from SAP PI( Integrated Security)

[Former Member]

Dear All,

I have an requirement to connect MS SQL server from PI using Operating system Authentication( my operating system is Windows 7)

In our JDBC connector we put windows authentication user, and the same user have given all access on Database level(MS SQL)

This is my JDBC connection details.

JDBC Driver:  com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://w99wxssrv.w07.net:6201;databaseName=Data_QA

UserName:

pwd:

If I put Database user and pwd , it works fine, this is our standard way.

But my requirement is , I need to use  windows user and pwd to connect the MS SQL database, but that user not be created in MS SQL database, but they give all the access to this user for logon.

I defined my parameters this way

JDBC Driver:  com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://w99wxssrv.w07.net:6201;databaseName=Data_QA;integratedSecurity=true

UserName: this user should be windows user

pwd: windows user pwd.

Connection Error: com.microsoft.sqlserver.jdbc.SQLServerDriver returns: This driver is not configured for integrated authentication.. : com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

Please give your hints on this. Thank you.

Best Regards,
Sateesh

[Former Member]

Hello All,

I am following this thread which is exactly related to my problem.

http://scn.sap.com/thread/3201721

But I need sqljdbc_auth.dll file to download, so far I didn't find right link to download.

Please suggest me.

Thank you.

Sateesh