SQL Monitor 13

Ignoring SSL certificate warnings when generating reports

In order to generate report PDFs, SQL Monitor connects to its Website service. If a website does not have a valid SSL certificate, this may fail:

The generation of reports for email may also fail, indicated by the following message in the logs:

ERROR RedGate.SqlMonitor.UI.Website.ReportPoller - System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.

The workaround is to disable SSL warnings by running the following SQL on the SQL Monitor repository:

Note: You will need to restart the SQL Monitor Base Monitor service for the settings change to take effect.

Reporting-IgnoreSSLErrors

USE [SqlMonitor]
GO

INSERT INTO [settings].[KeyValuePairs]
           ([KeyName]
           ,[KeyValue]
           ,[KeyValueType])
     VALUES ('Reporting-IgnoreSSLErrors','True','BOOLEAN')
GO



Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?