Report Builder 3.0 Unable to connect to Dataset

So, I had an issues with Report Builder not wanting to connect to the Database due to a certificate chain error in the prelogon handshake. I found this great post on TechNet Forums about the issue and it fixed it for me. There are detailed instructions on how to import the SCCM Database server’s certificate into your trusted root.

Start>run>mmc>file>add/remove snapins>certificate>Computer Account>Local Computer>Certificates>Personal>Certificates>Issued to: Name of server

 Look at each cert.  On the 3<sup style=”color:#1f497d;”>rd</sup> tab (Certification Path) it should say “ConfigMgr SQL Server Identification Certificate”.  Export that cert.

Then on the machine running report builder, import the certificate to the local computer trusted root.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s