Fix SCCM SQL Server Report Builder Access Error

Prajwal Desai
Last Updated :
Category : SCCM, SQL Server

LinkedInWhatsAppRedditPrint

Fix SCCM SQL Server Report Builder Access Error – While editing SCCM SQL server reports one of my colleague got an error. The error was “The certificate chain was issued by an authority that is not trusted”. Looking at the error it seemed like the error was linked to certificates. The description was 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.)

Fix SCCM SQL Server Report Builder Access ErrorNote that this error comes up when you don’t have SQL certificate installed on your computer. In one my posts i had shown how to create sql server identification certificate. The fix for this issue is simple. You export the SQL certificate from the SCCM server and import it to the machine where you are editing the reports.

Fix SCCM SQL Server Report Builder Access Error

Login to the SQL server. Click Start > Run > mmc. In the console click on file and then click Add/Remove Snap-in. In the next screen, select Certificates and then click Add. Choose Computer Account and click Next. On the next screen click Local Computer and click Finish. Click on Console Root > Certificates > Personal > Certificates. Right click on the ConfigMgr SQL Server Identification Certificate and click All Tasks > Export.

Fix SCCM SQL Server Report Builder Access ErrorIn the Certificate Export Wizard, click Next and click No, do not export the private key. Click Next.

Fix SCCM SQL Server Report Builder Access ErrorChoose the cert format as DER (.CER) and click Next. Choose a folder where you want to store the certificate and close the wizard.

Fix SCCM SQL Server Report Builder Access ErrorThe next step is to import the certificate on the client machine. On the client machine, open the Certificates snap in and click on Console Root > Certificates > Trusted Root Certification > Certificates. Right click and click All Tasks > Import.

Fix SCCM SQL Server Report Builder Access ErrorChoose the certificate that you exported in the above step. Click Next.

Fix SCCM SQL Server Report Builder Access ErrorYou have to place this certificate in Trusted Root Certification Authorities. Click Next and close the wizard. Now you should be able to edit the reports without any error.

Fix SCCM SQL Server Report Builder Access Error

Need Assistance?

Send us a message or post your question in forums.

email-symbolCONTACT online-communityforums email-verificationNEwsletter

Prajwal Desai

Prajwal Desai is a 7 time Microsoft MVP in Enterprise Mobility. With more than 10 years of content writing experience behind him, it's one of his favorite activities. His goal is to write comprehensive posts and guides, always aiming to help people with essential information.

6 thoughts on “Fix SCCM SQL Server Report Builder Access Error”

  1. Hello . I am trying to run the CMUUpdate Reset tool from cmd command and an error occured . [Error]
    0x80131904 – A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The target principal name is incorrect.) . In need this because i want to delete an installing update of SCCM console . Thank you

  2. Hey Prajwel, Thanks for putting this site together, it has been a huge help for me.

    I am facing an issue with the following error when trying to create a custom report:
    The target principal name is incorrect
    —————————-
    A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The target principal name is incorrect.)

    Wonder if you might be able to help?

    Thanks in advance

Comments are closed.