Network Management
When exporting a report in the SolarWinds Platform, Error The underlying connection was closed: could not establish trust relationship for the SSL/TLS secure channel
In ActionExecutionReport.log, when you try to export data, graphs, tables, or reports from the Orion Platform
First published date
Last published date
Overview
ERROR ReportingLogger - Action [Action: ID: 248, ActionType: SaveToDisk, Title: CSV - E:\RSA\REPORTS, Description: Save To Disk selected report in a specified format (CSV, PDF, or XLS), Enabled: True, Order: 1 , Context: EnviromentType: Reporting, for Account admin] execution has failed. 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 error is also noticed in scheduled reports for the same kind of reports above especially CSV / Excel type
Product section
Cause
- SolarWinds Web Console is using HTTPS:
- Certificate Authority (CA) (which signed the web console certificate) is missing in the Trusted Root Certificate Authorities Store. This is a common issue if the certificate is self-signed or signed by private certificate authority. If the certificate is signed by a public ca, this is less likely as long as Windows operating system is up-to-date.
- Common Name (CN) does not match the URL String. SolarWinds stores the hostname in the [dbo].Websites table in the SolarWinds database.
- Certificate is expired.
Resolution
To find the SSL certificate assigned to the SolarWinds web console, perform the following steps:
- Navigate to Start > Administrative Tools > Internet Information Service (IIS) Manager.
- Expand the Application Pool > Sites
- Right-click SolarWinds NetPerfMon website
- From the right-pane, select Bindings.
- Click the type HTTPS Port 443
- Select Edit.
- In the Add Site Binding window, go to the SSL Certificate
- Click Select (or View to view the Certificate).
- Click General Tab to confirm the Issued to (Common Name) and if there are any statements or purposes listed if there are none and these messages appear:
- This CA Root certificate is not trusted. To enable trust, install this certificate in the Trusted Root Certification Authorities store or
- This certificate cannot be verified up to the trusted certification authority
The CA certificate needs to be imported into the proper store, perform the following steps:
Important! Obtain the CA certificate from the certificate authority before performing these steps.
- Navigate to Start > Search MMC.exe
- Click File
- Select Add/Remove Snap-in... > Certificates
- Click Add
- Select Computer Account
- Click Next
- Select Local computer
- Click Finish > Ok
- From the left pane, select Certificate (Local Computer) > Trusted Root Certification Authorities
- Right-click, select All Tasks > Import
- Click Browse
- Select the CA certificate file (obtained from the certificate authority)
- Click Next
- Select Place all certificates in the following store: Trusted Root Certification Authorities
- Click Next > Finish
- Go back to Internet Information Services (IIS) Manager and restart the website.
Other Resolution :
- Common Name of the certificate MUST match the SolarWinds web console URL