I am attempting to update ignition from 8.1.22 to 8.1.33 on redundant servers. As of right now I have only performed the upgrade on one of them because my database connections (MS SQL) are faulted.
I have scoured here and the internet for solutions and feel I have exhausted my resources and possibly knowledge. Things I have done so far:
-downloaded new .jar file (jdbc with the .jre17 as the manual states)
-ensured that TLS 1.0 etc has been enabled in the java.security file
-added trustServerCertificate=true to the extra connection properties
There are 2 databases that are faulted (one running MS SQL 2008 and MS SQL 2008R2; and the other server running 2014 and 2008).
The final error with these changes I'm getting is:
"Cannot create PoolableConnectionFactory (Connection Reset)"
part in paranthesis cycles back and forth to:
(SQL Server did not return a response. The connection has been closed)
I appreciate any help provided, and I plan on calling tech support this afternoon if I don't figure this out.