Skip to Content
0
Apr 16, 2018 at 04:51 PM

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

244 Views

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.