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

Benoit LecoursSCCM, SSRS13 Comments

5
(4)

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.

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 4

No votes so far! Be the first to rate this post.

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

  1. Is this a common issue or does this have to do with how SQL is set up/configured?

    The reason for the question is that none of the documentation or tutorials about installing and using Report Builder detail anything about having to export/import certificates to connect to Data Sources and Datasets?

    I’m wondering if there’s a setting or something on our SQL server that’s triggering this error. Additionally, users can run the reports that we create without having to install the certificate from the server… so how is it that they can connect to and use the DataSource but yet we cannot make the same connection and create the report?

    Seems odd, doesn’t it?

    Chris

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

Leave a Reply