SAP Knowledge Base Article - Preview

3139913 - PI/PO - JDBC Adapter: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path

Symptom

When you use JDBC Adapter to establish connection from PI/PO system to MSSQL Server, it fails and you can find following stack traces in XPI inspector traces.
You configure connection string integratedSecurity=true.

[EXCEPTION]
com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: This driver is not configured for integrated authentication. ClientConnectionId:XXX.
: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:XXX
at com.sap.aii.af.lib.util.concurrent.AbstractResourcePool.getResource(AbstractResourcePool.java:160)
at com.sap.aii.adapter.jdbc.XI2JDBC.processMessage(XI2JDBC.java:386)
at com.sap.aii.adapter.jdbc.XI2JDBC.dispatchMessage(XI2JDBC.java:258)
at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:215)
...
Caused by: com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: This driver is not configured for integrated authentication. ClientConnectionId:XXX.
: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:XXX
at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:248)
at com.sap.aii.adapter.jdbc.JDBCConnectionPool.createNewResource(JDBCConnectionPool.java:67)
at com.sap.aii.af.lib.util.concurrent.AbstractResourcePool.getResource(AbstractResourcePool.java:151)
... 99 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:XXX
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2670)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:79)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:3381)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:85)
... 101 more
Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1959)
at java.lang.Runtime.loadLibrary0(Runtime.java:871)
at java.lang.System.loadLibrary(System.java:1134)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:54)
... 41 more


Read more...

Environment

  • SAP NetWeaver
  • SAP Process Integration

Product

SAP NetWeaver all versions ; SAP Process Integration all versions

Keywords

integratedSecurity, DriverManagerException, Cannot establish connection with the registered driver, This driver is not configured for integrated authentication, UnsatisfiedLinkError, no sqljdbc_auth, java.library.path, Process Integration, PI, Process Orchestration, PO, NetWeaver, XI, AEX, JDBC, JDBC Adapter , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.