Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Not what you were looking for? View more on this topic or Ask a question