Skip to Content

The driver could not establish a secure connection to SQL Server by using SSL encryption

I have a JDBC Adapter receiver communication channel in SAP NETWEAVER PI 7.1 which was previously connecting successfully and updating a SQL Database table. The Database is being migrated to Microsoft SQL Server 2016 from Microsoft SQL Server 2008. I have updated the communication channel with the new Database Connection details but I am getting the following error:

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: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: java.lang.ArrayIndexOutOfBoundsException: 64.. :

Does anyone know what is causing this?

Many thanks

Esther

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 12, 2018 at 03:26 PM

    Hi Ester,

    At this I'm having the same error by an upgrading made of Sql Server 2010 to a 2016 version, But I hadn't have find the right correction. Yo could fix your issue? If the answer is yes I'll be grateful for your help.

    Bye.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01 at 02:11 PM

    Hi

    It is a JDBC driver/Java/SQL Server/SAP PI version compatibility issue, which can only be resolved by an NW upgrade. We are part way through an upgrade to NW 7.5. We are using JDBC driver version 3.0 which is not compatible with SQL Server 2016, we need to be on JDBC driver version 4.0 minimum to be compatible with SQL Server 2016. We couldn’t move to a higher JDBC version as this would not be compatible with our current version of SAP Netweaver 7.1. We have Java version 5 which is compatible with NW 7.1, but once we go to NW 7.5 this is compatible with Java version 8.

    See SAP Note 1615198 and Microsoft JDBC Driver for SQL Server Support Matrix link below to understand which versions you must be at for all 4 areas:

    https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-2017

    Hope this helps.

    Esther

    Add comment
    10|10000 characters needed characters exceeded