在运行 SQL Server 2008R2 的 Windows 2008R2 SP1 服务器上,每隔约 60 秒我就会收到以下两个错误:
第一的:
Log Name: System
Source: Schannel
Date: 5/25/2016 9:23:02 AM
Event ID: 36888
Task Category: None
Level: Error
Keywords:
User: SYSTEM
Computer: sql1.contoso.com
Description:
The following fatal alert was generated: 43. The internal error state is 552.
第二:
Log Name: System
Source: Schannel
Date: 5/25/2016 9:23:02 AM
Event ID: 36884
Task Category: None
Level: Error
Keywords:
User: SYSTEM
Computer: sql1.contoso.com
Description:
The certificate received from the remote server does not contain the expected name.
It is therefore not possible to determine whether we are connecting to the correct server.
The server name we were expecting is sql1.
The SSL connection request has failed. The attached data contains the server certificate.
第二个错误描述中的服务器名称与计算机字段中的 FQDN 是相同的主机名。
从 sql1.contoso.com 到另一台计算机、从另一台计算机到 sql1.contoso.com 以及从 sql1.contoso.com 到其自身的 SSL 连接是否失败?
如果涉及另一台服务器,我如何确定哪个服务器是源服务器或目标服务器?
非常感谢任何有关追踪问题根源和解决方案的帮助。
答案1
你尝试过这个吗?
https://support.microsoft.com/en-us/kb/2275950
它说: ”... Windows 2008 r2 上存在一个已知的错误,该错误可能会导致有效证书被拒绝。“。这似乎符合你身上发生的事情的描述,不是吗?