Fix SCCM SQL Server Report Builder Access Error

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.)

Note 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.

In the Certificate Export Wizard, click Next and click No, do not export the private key. Click Next.

Choose the cert format as DER (.CER) and click Next. Choose a folder where you want to store the certificate and close the wizard.

The 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.

Choose the certificate that you exported in the above step. Click Next.

You 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.