无法连接到以下 SQL Server:“WinSrv2019”。请验证该服务器是否已启动并正在运行，并验证您是否具有 SQL Server 管理凭据。[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL 安全错误。
Description
Tasks using 'Microsoft OLE DB Provider for SQL Server' are failing with the following error:
Possible Error 1:
Error: Connector connect error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
Possible Error 2:
ErrorMsg: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
Environment:
Possible Error 1:
Error: Connector connect error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
Possible Error 2:
ErrorMsg: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
Environment:
- All QlikView versions
- All Qlik Sense versions
Cause
Microsoft OLE DB Provider for SQL Server is not support with TLS 1.2 version or TLS 1.0 is not enabled on Windows 2016 Server.
Resolution
Enable TLS 1.0 for Microsoft OLE DB Provider for SQL Server on SQL Server.
TLS 1.0 can be enabled with the following registry changes:
TLS 1.0 can be enabled with the following registry changes:
- [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server] "Enabled"=dword:00000001
- [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server] "DisabledByDefault"=dword:00000000
- [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client] "Enabled"=dword:00000001
- [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.
