cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot establish JDBC connection to SQL Server 2008 from SAP PI 7.0 EHP 2

santhosh_sontha2
Explorer
0 Kudos

Dear All,

We have a working scenario where our SAP PI 7.0 server(EHP2)
connected to legacy SQL server 2005 since 3 years.

Now legacy migrated from SQL Server 2005 to SQL Server 2008.
We started getting error as below 

“JDBC
message processing failed; reason 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 with the registered driver.
com.microsoft.jdbc.sqlserver.SQLServerDriver returns: [Microsoft][SQLServer
2000 Driver for JDBC]Error establishing socket.. : SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket”

To fix it we downloaded the compatible JDBC driver “sqljdbc_1.2.2828.208_enu”
from Service Marketplace and deployed in SAP PI
7.0 server. By this we have following jar files in server:

  1. msbase.jar
  2. mssqlserver.jar
  3. msutil.jar
  4. mysql-connector-java-5.0.3-bin.jar
  5. sqljdbc.jar
    New Jar file after deploying sqljdbc_1.2.2828.208_enu

         

& Receiver communication channel configured as :

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

Connection = jdbc:sqlserver://IPAdd:2571;databaseName=XXXX

(Note : SQL Server 2008 not using default port 1433 instead using 2571)

After this still we are getting the same error as above.
Telenet to the SQL server from PI server is working fine, also we are able to
connect to new SQL Server through SQL Manager studio.

Please advise on this.

Regards,

Santhosh

Accepted Solutions (0)

Answers (2)

Answers (2)

nabendu_sen
Active Contributor
0 Kudos

Hi Santosh,

Is this new port "2571" added in Network Firewall so that it can pass? Check with Network Administration team.

santhosh_sontha2
Explorer
0 Kudos

Dear Nabendu,

Port 2571 is opend in network firewall. We are able to telnet from PI server to the MS SQL server 2008.

Regards,

Santhosh

Former Member
0 Kudos

Hi Santosh,

Remove the databasename and test once.

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

Connection = jdbc:sqlserver://IPAdd:2571

Regards

Kiran

Former Member
0 Kudos

Hi Santhosh,

Please go through the below link.

https://scn.sap.com/message/8827123

Regards

Venkat

santhosh_sontha2
Explorer
0 Kudos

Dear Venkat,

We refered this blog & applied drivers(

aii_af_jmsproviderlib.sda)

from Service market place, but no luck.

Regards,

Santhosh