The following error may occur during initial installation of the Change Auditor Coordinator at the SQL server and instance screen, or may also be observed post installation as well, within the Coordinator log when it attempts to connect to the SQL database.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The handle specified is invalid)
The Change Auditor server and SQL server may have conflicting SSL/TLS configuration.
For example, the error above may be caused if the server hosting the Change Auditor Coordinator has a GPO applied to disable TLS 1.0.
To resolve this issue, ensure there are no conflicting SSL/TLS settings applied to either the Change Auditor Coordinator server or the SQL server.
More information on this error can be found in the following external links:
https://support.microsoft.com/en-ca/kb/245030
https://blogs.msdn.microsoft.com/dataaccesstechnologies/2015/07/09/an-error-occurred-during-the-pre-login-handshake-dbnetlibconnectionopen-secdoclienthandshake-ssl-security-error-when-connecting-to-sql-server/
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy