

This alert detects TLS/SSL certificate validation errors in system logs, such as failures to establish a trust relationship for secure channels. These errors typically occur when certificates are expired, untrusted, or misconfigured, potentially disrupting secure communications between services and users.
Definite Impact:
Possible/Likely Impact:
Follow the steps below to diagnose and resolve the issue:
Check the certificate being used for secure communication:
If any of your certificates do not adhere to the above requirements, use the steps below to replace them:
Location: Public and Internal Web Servers
iisreset
) or from IIS ManagerNote: If using a self-signed certificate, ensure it is manually trusted and imported on all relevant servers: Web, SQL, Agents, Workers, Queue Manager, and Analytics.
Location: SQL Server
Note: �MSSQLSERVER� is the default instance name. If a custom name is used during setup, select that option instead.
Reference:For more detailed guidance on managing SQL Server TLS Certificates, refer to MS documentation:
Secure Analytics (CAAT) with TLS. Ensure the appropriate certificate is selected and trusted by all communicating machines.
Note: Self-signed certificates used here must also be trusted by all servers interacting with Analytics.
Ensure that the hostname used in the connection matches the Common Name (CN) or Subject Alternative Name (SAN) specified in the TLS/SSL certificate.
Confirm that the system clocks on all servers are synchronized and set correctly, as significant time discrepancies can cause TLS/SSL handshake failures.
Utilize tools like openssl s_client, curl -v, or browser developer tools to test SSL/TLS connections and identify specific issues in the handshake process.
This alert monitors log entries for TLS/SSL certificate validation errors like:
"Could not establish trust relationship for the TLS/SSL secure channel."
Rule Type | Value | Description |
---|---|---|
Data View | Logs-* | |
Filter Query | message: "Could not establish trust relationship" | Filters for matching error message |
Group | Count | |
Threshold | > 0 | Count greater than 0 triggers the alert |
Time Window | 1 hour | Checks logs from the past hour |
Frequency | 1 minute | Evaluates every minute |
logging
Message
Attribute Name | Description | Value |
---|---|---|
Log level | Severity of the log entry generated during certificate errors | Error |
Why was this not helpful?
Check one that applies.
Thank you for your feedback.
Want to tell us more?
Great!