-
Title
A connection was successfully established with the server, but then an error occurred during the pre-login handshake -
Description
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)
-
Cause
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.
-
Resolution
To resolve this issue, ensure there are no conflicting SSL/TLS settings applied to either the Change Auditor Coordinator server or the SQL server.
Depending on the security protocol referenced in the SChannel error and/or the SChannel settings on the SQL server investigate the following registry hive to see if the required SSL/TLS protocols have been disabled or otherwise require attention on the servers in question:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\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/