Follow these instructions if Meridian is not connecting to SQL and the following message appears in the event log:
"HTIOError (ht5) (HTE_SQL_Failed=802) [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error."
This issue occurs due to the disablement of TLS 1.0 and 1.1 by Microsoft.
Solution
To solve this issue, enable TLS 1.0 and 1.1.
-
Navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client
Set "Enabled" to: dword:00000001
-
Navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client
Set "DisabledByDefault" to dword:00000000
-
Navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server
Set "Enabled" to: dword:00000001
-
Navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server
Set "DisabledByDefault" to: dword:00000000
