sccm.haas.se
14Jan/140

Report Builder can’t connect to SQL Server

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

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

Choose Computer Account after you press “Add”.

MMC Computer

You will then export the “ConfigMgr SQL Server Identification Certificate” from the Personal Store on the SQL-server.

Export Certificate

Export2

Do not export the Private Key

Private key no

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

After that you should be able to connect to the Data Source without problems.