on 01-14-2013 7:03 AM
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:
& 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
Hi Santosh,
Is this new port "2571" added in Network Firewall so that it can pass? Check with Network Administration team.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santosh,
Remove the databasename and test once.
JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection = jdbc:sqlserver://IPAdd:2571
Regards
Kiran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.