I’m running Lucee 188.8.131.52 in a docker container using this image - https://hub.docker.com/r/lucee/lucee52-nginx/. 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?