http://coldfusion.com logo
Join Slack
Powered by
Anyone came across the below error while connectin...
# cfml-general
v
Anyone came across the below error while connecting to the Azure Database instance
Copy code
Connection verification failed for data source: <<>>
macromedia.jdbc.sqlserverbase.dden: [Macromedia][SQLServer JDBC Driver][SQLServer]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.
The root cause was that: macromedia.jdbc.sqlserverbase.dden: [Macromedia][SQLServer JDBC Driver][SQLServer]Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.
Coldfusion 2016 😞 - Update 17 Enabled TLS 1.0/1.1/1.2 on the CF server Azure Setting : TLS 1.2
z
how old is your java?
v
Copy code
java -version
openjdk version "17.0.4.1" 2022-08-12 LTS
OpenJDK Runtime Environment Microsoft-40354 (build 17.0.4.1+1-LTS)
OpenJDK 64-Bit Server VM Microsoft-40354 (build 17.0.4.1+1-LTS, mixed mode, sharing)
p
Could try to add this to your Cf admin Java JVM settings: ‘-Dhttps.protocols=TLSv1.2,TLSv1.1,TLSv1’ and then restart CF
But not sure if that will help with the data source connection directly
r
CF 2016 doesn't support Java 17. Are you sure it's actually using the Java version you posted? What is reported by system information in the ColdFusion Admin?
Also, try Patrick's suggestion but drop the older protocols, so something like 
-Dhttps.protocols=TLSv1.2
and the latest version of Java 11 (or 17 if you actually have it working). Your OS may need to add support as well, especially if you are running an older version of Windows Server. IIS Crypto is a good utility to configure TLS support on Windows.
Note that dropping older protocols may break connections to other servers so you'll have to test different versions.
☝🏻 1
v
Windows Server 2022 Datacenter ( It is also an Azure VM)
Also I installed SSMS in the CF App server and able to connect to the DB
r
That sounds like the Java version your CF instance is using doesn't support TLS 1.2. Did you confirm what version CF is using by going to System Information in the CF admin?
v
Copy code
java.sql.SQLException: No suitable driver available for <<Datasource>>, please check the driver setting in resources file, error: com.microsoft.sqlserver.jdbc.SQLServerDrive
It is pointing to the Open JDK latest version
r
What version? You posted 17 earlier, but that isn't a supported version. It should look similar to this:
Open in Slack
PreviousNext
Powered by