You try to connect to the SCCM 2012 Data Source but Report Builder throws this error:
“A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)”
![2014-01-14 11-28-13](http://sccm.haas.se/wp-content/uploads/2014/01/2014-01-14-11-28-131-450x329.png)
This is because the connection needs to be authenticated by the means of a certificate that is on the SQL-server which your client doesn’t have. You need to export the “ConfigMgr SQL Server Identification Certificate” from your SQL Server Personal store to your clients Trusted Root store. Here’s a How-To:
On the SQL-Server, open an MMC and from the File Menu, choose Add/Remove Snap-in and then choose Certificates.
![Certificates MMC](http://sccm.haas.se/wp-content/uploads/2014/01/Certificates-MMC1.png)
Choose Computer Account after you press “Add”.
![MMC Computer](http://sccm.haas.se/wp-content/uploads/2014/01/MMC-Computer1-450x332.png)
You will then export the “ConfigMgr SQL Server Identification Certificate” from the Personal Store on the SQL-server.
![Export Certificate](http://sccm.haas.se/wp-content/uploads/2014/01/Export-Certificate1-1024x151.png)
![Export2](http://sccm.haas.se/wp-content/uploads/2014/01/Export21-359x212-custom.png)
Do not export the Private Key
![Private key no](http://sccm.haas.se/wp-content/uploads/2014/01/Private-key-no-450x406.png)
Put the certificate somewhere where you can import it from your computer with Report Builder.
On the computer with Report Builder, open a new MMC-console. Add the Certificate Snap-in for that computer and then import the certificate that you exported above into the Trusted Root Store.
![Cert import](http://sccm.haas.se/wp-content/uploads/2014/01/Cert-import1.png)
After that you should be able to connect to the Data Source without problems.