Symptom
- You have a Process Integration (PI) or Process Orchestration (PO) JDBC Adapter scenario connecting to a Microsoft SQL Server 2005 database (identical can happen with other MS SQL DB versions e.g. Microsoft SQL Server 2012)
- This may have been working successfully previously.
- Possibly there has been some recent software updates on the PI/PO system, SPS update and SAP JVM version update.
- After this, the integration stops working and you get the error below:
- [EXCEPTION]
MP: exception caught with 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: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS12]". OR - [EXCEPTION]
com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)"..
: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)"
- [EXCEPTION]
Read more...
Environment
- SAP NetWeaver 7.5
Product
SAP NetWeaver 7.5
Keywords
JDBC, SSL, TLS, protocol exception, Unexpected rethrowing, TLS 1.0, TLS 1.1 , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.