SQL Server Driver Exception -SAP PI 7.1

[Former Member]

Getting the following exception while connecting the sender to the sql server database.

Accessing database connection 'jdbc:microsoft:sqlserver://10.10.20.158\staging:1433;databaseName=ProfileData3;' failed: 
[EXCEPTION]
com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: com.microsoft.sqlserver.jdbc.SQLServerDriver.
: SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:160)
at com.sap.aii.adapter.jdbc.JDBC2XI.connectDB(JDBC2XI.java:1535)
at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:334)
at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:534)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
------------------------- Loader Info -------------------------
ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]
Living status: alive
Direct parent loaders:
   [system:Frame]
   [library:com.sap.aii.af.sdk.lib]
   [service:com.sap.aii.af.svc]
   [service:com.sap.aii.adapter.xi.svc]
   [library:com.sap.aii.adapter.lib]
Resources:
   /usr/sap/P01/DVEBMGS01/j2ee/cluster/bin/services/com.sap.aii.adapter.jdbc.svc/lib/com.sap.aii.adapter.jdbc.svc_api.jar
---------------------------------------------------------------
at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:274)
at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:243)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:95)
... 7 more
Caused by:
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
------------------------- Loader Info -------------------------
ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]
Living status: alive
Direct parent loaders:
   [system:Frame]
   [library:com.sap.aii.af.sdk.lib]
   [service:com.sap.aii.af.svc]
   [service:com.sap.aii.adapter.xi.svc]
   [library:com.sap.aii.adapter.lib]
Resources:
   /usr/sap/P01/DVEBMGS01/j2ee/cluster/bin/services/com.sap.aii.adapter.jdbc.svc/lib/com.sap.aii.adapter.jdbc.svc_api.jar
---------------------------------------------------------------
at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:274)
at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:243)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:95)
at com.sap.aii.adapter.jdbc.JDBC2XI.connectDB(JDBC2XI.java:1535)
at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:334)
at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:534)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280)

[iaki_vila · Accepted solution]

Hi Naveed,

Are you sure that you have deployed right the drivers?. Please check these notes

2063879 - PI JDBC Adapter - driver is not configured for integrated authentication

2232201 - SAPClassNotFoundException thrown by JDBC adapter while connecting to Microsoft SQL Server ...

Regards.

[Former Member · Accepted solution]

What is the procedure of deploying the sqljdbc driver on the linux machine. -Mannual process.

[iaki_vila · Accepted solution]

Hi Naveed,

You can check this note: 1138877 - How to Deploy External Drivers JDBC/JMS Adapters

And this example for PI 7.1: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

Finally this note can help you to know if the drivers has been installed correctly:   1829286 - PI: How to check which drivers are installed for the JMS and JDBC Adapters

Regards.