UD Connect from SAP NetWeaver 7.01 J2EE AS to MS SQL Server 2016

[milan_sadil1]

I have read very useful wiki page from Sandor Szalina (https://wiki.scn.sap.com/wiki/display/SAPSQL/Java+AS+connection+issues) and also Note '1428134 - sqljdbc driver fails to establish secure connection'. Both materials mention an error 'The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: java.lang.ArrayIndexOutOfBoundsException'. The note suggests to disable two newer cipher suites - TLS_DHE_RSA_WITH_AES_128_CBC_SHA and TLS_DHE_RSA_WITH_AES_256_CBC_SHA on MS Windows Server 2012/2016 (on a box where MS SQL Server 2016 runs). Could someone confirm that the solution suggested really works - in case of SAP NetWeaver 7.01, i.e. in of SAP JVM 1.4.2, i.e. in case of JDBC Driver 1.2? In other words - is it possible to connect from SAP NetWeaver 7.01 to MS SQL Server 2016 using JDBC Driver 1.2?

It seems that there is a similar question asked at https://answers.sap.com/questions/414246/the-driver-could-not-establish-a-secure-connection.html.

[cherry_tian]

There is another note for this error

2356977 - Error during connection of JDBC Driver to SQL Server

If you are on Windows 2012, you need to implement it.

Best regards,

Cherry.

[cherry_tian]

Hi, Milan

Could you please check about note 1398807. It contains the information about the support matrix with the combination of SAP release, SQL Server release, and JDBC driver version.

1398807 - Microsoft SQL Server: JDBC driver support matrix

Best regards,

Cherry.