I’m running Lucee 5.2.7.62 in a docker container using this image - Docker. I’m trying to create a datasource that connects to an MS SQL database. I’m running into the following error when I try to create a datasource that connects to an MS SQL database:
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.
I tried the following via the Lucee administrator without success:
- Updated the JDBC driver from Microsoft SQL Server to 6.2.2.jre8 from 4.0 (restarted Lucee and tried to create the datasource).
- Re-installed the 6.2.2.jre8 driver .
I’m able to create the datasource using the jTDS driver. Should I just use the jTDS driver? What are the downsides (if any) of using the jTDS driver?