Report Builder Error – The Certificate Chain was issued by an Authority that is not Trusted

Benoit LecoursSCCM, SSRS12 Comments

When editing a SCCM 2012 report in Report Builder you receive the following error : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)

Report Builder error

Cause

This error occurs because you don’t have the required SCCM SQL certificate on the computer running Report Builder. Follow the following steps in order to resolve the issue.

Export the certificate from your SQL server

  • On the SQL Server
  • Click the Start menu, click Run, and then type mmc. Click Enter. This starts the Microsoft Management Console (MMC)
  • In the console, click the File menu and then click Add/Remove Snap-in

Report Builder error

  • On the Snap-in list, select Certificates and then click Add

Report Builder error

  • In the Certificates Snap-in window, select Computer account, and then click Next

Report Builder error

  • In the Select Computer window, select Local computer, and then click Finish. This adds the Certificates Snap-in to the list. Close the window.

Report Builder error

  • Browse to Console Root / Certificate (Local Computer) / Personal / Certificates
  • Right-click your ConfigMgr SQL certificate

Report Builder error

  • Select All Tasks and Export

Report Builder error

  • Select default choices in the Certificate Export Wizard (Next,Next,Next)
  • Export the certificate file (.CER) to the machine where you run Report Builder

Import the certificate on your machine

  • On the machine running Report Builder
  • Click the Start menu, click Run, and then type mmc. Click Enter. This starts the Microsoft Management Console (MMC)
  • In the console, click the File menu and then click Add/Remove Snap-in
  • In the Add/Remove Snap-in window, click the Add button
  • On the Snap-in list, select Certificates and then click Add
  • In the Certificates Snap-in window, select Computer account, and then click Next
  • In the Select Computer window, select Local computer, and then click Finish. This adds the Certificates Snap-in to the list. Close the window
  • Browse to Console Root / Certificate (Local Computer) / Trusted Root Certification Authorities / Certificates
  • Right-click Certificate and select All Tasks / Import

Report Builder error

  • In the Certificate Import Wizard click browse and select the exported certificate

Report Builder error

  • Ensure that the certificate is placed in the Trusted Root Certification Authorities, click Next

Report Builder error

  • Click Finish to complete the wizard

That’s it, reopen Report Builder and the error will be gone.

12 Comments on “Report Builder Error – The Certificate Chain was issued by an Authority that is not Trusted”

  1. Pingback: Erro ao editar relatórios do Report Builder do SCCM | Márcio Hunecke – marciohunecke@hotmail.com

  2. I was stuck for a while not being able to launch the query builder in SQL Server Report builder until I came across this. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *