Connection Failed error message for JDBC Driver "SAPClassNotFoundException"

[naimkhans_babi]

Dear Friends

I have strange problem. I am failed to connect with SQL Server from PI Quality system. My configuration of communication channel is working perfectly fine in Development system. Same configuration for Communication channel is not working in Quality system.

Below is the error log from communication channel monitoring.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://*************;databaseName=*************;user=sa;password=***************;':

SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrive

Please tell me how can I solve this problem. Any reply from you will be appreciated greatly.

Thanking you

Regards

Naeem

[naveen_chichili · Accepted solution]

Hi Naeem,

Try restarting the JDBC channel it will work. if not try to increase the thread count for JDBC Adapter.

Regards,

Naveen

[baskar_gopalakrishnan2]

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://**************;databaseName=***************;user=sa;password=****************;': 

SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDrive

JDBC Drivers for MS SQL Server is not installed in QA box. Please check that.

[Former Member]

20. ClassNotFoundException while using SQL Server 2005 Driver

Q: I am not able to connect to DB using SQL Server 2005 driver if I use com.microsoft.jdbc.sqlserver.SQLServerDriver as driver class name. I get [classNotFoundException|http://sapnwnewbie.blogspot.com/2011/09/sapclassnotfoundexception-when-using.html]. Why?

A: Driver class names for SQL Server 2000 driver and SQL Server 2005 driver are different.

If you are using SQL Server 2005 driver, then class name should be as follows:

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

URL :jdbc:sqlserver://<db_Server>:port;databaseName=< db_name>

If you are using SQL Server 2000 driver , then class name should be as follows:

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

and URL is as follows:

jdbc:microsoft:sqlserver://<db_server>:port; databaseName=<db_name>

[Former Member]

Hello,

You could also check note:

831162 FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

question

20. ClassNotFoundException while using SQL Server 2005 Driver

Regards

Sarah

[PriyankaAnagani]

Hi,

This might be driver problem....please check wheck whether drivers installed properly or not..Please check the below link

Regards

Priyanka