We are getting the following error on a table.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Connection reset".
We have updated the security file to remove TLS v1 and v1.1 awhile ago.
all of our other connections are working.
Connection reset might be a firewall issue.
Would the firewall issue be on the Ignition gateway or the SQL server VM? you would think it wouldn't be on the Gateway as we already have multiple SQL connections.
Likely on the other end, given the working connections. Unless the ports differ among them. Are all of the SQL Servers running the same version?
No we have one running 8.00.2187 (which is the one not working) and one that is working is version 13.0.6
Are you sure that old version is supported by the JDBC driver? Did it stop working recently? Or has it ever worked since you updated the TLS settings?
Any chance your firewalls have been updated to block old TLS? (They should, really.)
I am trying to double check the VM security file TLS but there is no
C:\Program Files\Inductive Automation\Ignition\lib\runtime\jre-win\conf\security
Would it be somewhere else?
Not sure. I rarely deal with Windows. If you upgraded Ignition, the past changes to that security file would have been wiped out.
There won't be a lib\runtime\ folder if this is 7.9, as the topic tags suggest. In which case you're at the mercy of your system's installed JVM(s), which likely were updated without your knowledge.
Found it, but TLS 1 and 1.1 are already removed