If you’re like us and love to create and build awesome reports, you may get an error when running report builder on a remote computer. When editing an SCCM report in Report Builder you may 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.)

SCCM Report Builder error

SCCM 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
  • On the Snap-in list, select Certificates and then click Add
SCCM Report Builder error
  • 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.
SCCM Report Builder error
  • Browse to Console Root / Certificate (Local Computer) / Personal / Certificates
  • Right-click your ConfigMgr SQL certificate
SCCM Report Builder error
  • Select All Tasks and Export
SCCM 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 SQL certificate on the remote 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
SCCM Report Builder error
  • In the Certificate Import Wizard click browse and select the exported certificate
  • Ensure that the certificate is placed in the Trusted Root Certification Authorities, click Next
SCCM Report Builder error
  • Click Finish to complete the wizard

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

Comments (13)

clewis

07.15.2020 AT 10:39 PM
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

Roger

05.10.2019 AT 12:36 PM
I needed to also import into my Trusted Root Certification Authorities store

Ali

03.08.2019 AT 04:25 AM
Thanks Benoit! Perfect!

Onurb

10.24.2018 AT 09:03 AM
Error, Cause, Solution... and pictographic. Fixed in less than a minute. Thank you.

Rodrigo

04.17.2018 AT 03:06 PM
Excellent post, thank you.

Mike

10.15.2017 AT 11:35 AM
Thanks. Worked perfectly!

Jose Sisto

07.20.2016 AT 02:35 PM
Worked like a charm, thanks Benoit!

Adriana

02.22.2016 AT 06:10 PM
What can I do if the server doesn't have a SQL certificate that I can Import to my computer?

Benoit Lecours

03.03.2016 AT 10:02 AM
Every SQL sever should have a certificate. Can you give more detail on your setup ? Maybe this thread could help you : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9b29f5e8-67fc-40d1-9bde-1521cbdfe07e/sql-server-2008-ssl-certificate-list-blank?forum=sqlgetstarted

Chris

02.04.2016 AT 02:08 PM
Thank you for posting this, it quickly showed me the steps for correcting my connection issues.

Jon

10.08.2015 AT 02:03 PM
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!

Benoit Lecours

10.09.2015 AT 06:22 AM
Thanks for the feedback !