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.
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
Hi! I have the same problem.
Still not resolved(
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
Are the SQL services in started state ?.
Hi! I have the same problem.
Still not resolved(
SQL services is started
Once again thank u SIR!