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