on 12-18-2018 6:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.