I am trying to utilize a “Hub and Spoke” style architecture where the SQL Bridge Module is at a remote site and logging data to a centralized database across the web. I have enabled SSL on the gateway and it works as desired for gateway and client access. However, when I set the "Force Encryption" setting on my SQL server (within SQL Server Configuration Manager) the connection fails.
I am not sure if the break is on the SQL server side or the JDBC driver side...
• I’ve been using a self-signed certificate created on the SQL server
• The Connect URL looks as follows:
• The Extra Connection Properties looks as follows:
If I leave the database connection exactly the way it is but change the "Force Encryption" setting on the SQL server it connects without issue. I apologize for the poor formatting of the attached stack but I wasn't able to get it out of the browser any cleaner.
SQL Server 2008
Windows Server 2008
Default JDBC driver “sqljdbc4.jar”
I appreciate how active these forums are as they've certainly helped me already. If anyone has any experience with SSL+SQL the input is appreciated!