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.

http://social.technet.microsoft.com/Forums/en-US/add3e017-6166-4443-b9f2-9898e4e0c843/report-builder-unable-to-connect-to-data-source?forum=configmanagergeneral

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.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s