Skip to Content
0
Dec 18, 2018 at 06:29 AM

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

502 Views Last edit Dec 18, 2018 at 01:58 PM 2 rev

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