May 8, 2017 at 2:35 pm
Hello experts,
I know I shouldn't find this so difficult, but I'm having trouble configuring a web server data source to connect to SQL Server 2016. The server is ColdFusion 10, and the SQL Server is using a non-default port and requires an SSL connection, and I can't get the data source to verify successfully.
This is one error, about the SSL:
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.
The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.
Another couple of wrinkles are (1) that the ColdFusion administrator has a form for the connection info (JDBC url, user, pw, etc.) but also a Connection String box that supposedly overrides the form entries. So it is tough for me to see whether to fill out one, the other, or both; and (2) I am not sure if I should use the version 4.0 or version 6.0 JDBC drivers for SQL Server that Microsoft offers.
Could someone point me to some information on properly configuring this kind of data source?
Thanks for any help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply