intermittent SQL connection failures for different SQL tasks like
2021-06-29 07:05:21.890 [33][INFO][Quest.Data.ExceptionSql.OnExceptionSqlEvent(0)] SQL error(-2146232060): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.);
The behavior is similar to the issue outlined in the following MS Article:
Applications experience forcibly closed TLS connection errors when connecting SQL Servers in Windows
To fix this issue, make sure that both the client and server involved in a connection are running Windows that have the leading zero fixes for TLS_DHE installed. It's recommended to install the updates since they enhance the conformance to TLS_DHE specifications.
The SQL server is 2016 and has a windows update which should contain a fix for the issue but the Coordinator is Windows 2012R2 which does not have a Windows update with a fix.
Apply the workaround discussed in the article to the coordinator server and reboot.
