i'm not sure whether to ask this on dba.stackexchange.com or here.
Periodically following error is logged in Windows Server 2008 Administrative events:
The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The SSL connection request has failed. The attached data contains the server certificate.
Log Name: System
Source: Schannel
Followed by:
The following fatal alert was generated: 48. The internal error state is 552.
Log Name: System
Source: Schannel
If i change the Force Encryption
property in SQL-Server Configuration from "No" to "Yes"(see image below) the error would not be logged anymore.
But i don't really need SSL-Encryption since all connections are trusted(from intranet) and ports 1333 and 1334 are firewalled from internet.
Would it be a performance impact if i would force encryption and generate a server certificate, is it recommended at all in my situation? I don't want to enforce encryption only to prevent from some event logs if it not even causes serious connection problems(where can i see which connection has caused it?).
Q: Can somebody please explain why these errors are raised and wherefrom?