mikebai.com

  • Home
  • dev
  • DotNET
  • M365
  • 搞笑
  • 杂七杂八
  • FocusDict
個人BLOG
it developer
  1. Main page
  2. dev
  3. Main content

crm 2016 server安装--SSL Security error using Microsoft OLE DB Provider for SQL Server

2019-07-27 112hotness 0likes 0comments

无法连接到以下 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: 

  • 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:

  • [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.
Tag: Nothing
Last updated:2019-07-27

mikebai

This person is a lazy dog and has left nothing

Like
< Last article
Next article >

COPYRIGHT © 2025 mikebai.com. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang