The driver could not establish a secure connection to SQL Server using SSL using JDBC
Dear Sir/Mdm,
I'm setting up a DR server for my JDE E9.10, using MS SQL 2012 Ent, but unable to connect to the SQL Server using JDBC driver sqljdbc4.jar or sqljdbc41.jar or sqljdbc42.jar either using jdk 1.6.0_21 or jdk 1.7.0_80 or jdk 1.7.0_67. I'm configuring the Server Manager Console 9.1.4.6.
The ODBC also required to install MS SQL Management Studio or SQL 2012 Native client to connect instead of standard SQL Client 11.0.
The error is
Unable connect to the bootstrap datasource. The supplied credentials may not be valid, or the datasource may not be configured correctly. :[DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 910.: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionID:50b9e156-faac-45f7-9eb4-57ff1d30bf06".: SQL Server did not return a response. The connection has been closed. ClientConnectionID:50b9e156-faac-45f7-9eb4-57ff1d30bf06