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

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

• SAP NetWeaver 7.5

Process Orchestration 7.50, PI 7.50, PO 7.50, NetWeaver, XI, JDBC, SSL, TLS, protocol exception, Unexpected rethrowing, TLS 1.0, TLS 1.1 , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem