cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot connect to Microsoft SQL Server 2014 - 12.0.2269.0 (X64) using jdbc Receiver Channel adapter.

former_member221486
Participant
0 Kudos

Hi PI Experts,

Am been facing issue which SAP PI 7.4 JDBC Reciver Channel in not able to establish the connection to MS SQL Server 2014 which is on AWS.

We have deployed sqljdbc4.jar in PI Server and the configuration maintained in the channel as below.

JDBC Driver: "com.microsoft.sqlserver.jdbc.SQLServerDriver"

Connection: "jdbc:sqlserver://Sqlserver:1433;databaseName=db_name"

Initially there were some firewall is blocking the connection and Network team have opened the same.

Error Log as shown in Channel Log:

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: 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: Login failed for user 'SAP_PI'..

: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SAP_PI'.

Please advise on the same, whether any user or connection specific settings need to be configured..?

Or do we need to upgrade our JDBC driver installed in PI.

Please suggest.

Thanks,

Chaitanya

Accepted Solutions (0)

Answers (2)

Answers (2)

faisonli
Explorer
0 Kudos

Hello Chaitanya,

PI 7.4 is compatible with Java 6. So firstly, you need to contact your DB vendor MSSQL server to download correct JDBC jar file which is compatible with Java 6. See 1615198 - PI JDBC and JMS Adapter driver's JRE compatibility

After that, make sure this external JDBC jar file deployed on PO system correctly.

See 1829286 - Checking the drivers installed for the JMS and JDBC Adapters and 2513069 - How to deploy the external drivers for Axis/JDBC/JMS Adapter - Guided Answers

Best Regards, Faison

0 Kudos

Hi Chaitanya,

I would suggest to check the reported user from the error message.
Check that it is not locked and the credentials are correct.

Regards,
Balázs

former_member221486
Participant
0 Kudos

Hello Barna,

The user details are correct. I have checked with third party system they confirmed that details are correct. They can able to login at there side.

but PI throwing this above error in channel communication.