SAP Knowledge Base Article - Preview

3307638 - PI/PO JDBC Adapter integration fails with error - the driver could not establish a secure connection

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)"


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.