ConfigMgr 2012 – Custom Reports – Can’t connect to Data Source

2017-12-01T16:16:05+00:00 July 30th, 2013|Azure, Windows|

Using ConfigMgr 2012 with Report Builder 3.0 from a remote console one user was receiving an error when creating a custom report.

The error was: A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error:0 – The wait operation timed out.)

Investigations led to checking the certificate store on the local machine as we knew this worked from the Primary site server.

The final resolution was:

  • Open MMC on the SCCM SQL server
  • File > Add/Remove Snap-ins
  • Select Certificates > Computer Account
  • Select Local Computer and Click Ok to load the snap-in
  • Expand Certificates > Personal > Certificates
  • Right-Click the Certificate that is Issued To and Issued By your SCCM SQL Server and Select All Tasks > Export
  • Export with a Private Key
  • Enter a password
  • Browse to a location where you want to save the export certificate and enter a name for it.
  • Finish the Wizard.

Now on the machine suffering from the error:

  • Open MMC on the SCCM SQL server
  • File > Add/Remove Snap-ins
  • Select Certificates > Computer Account
  • Select Local Computer and Click Ok to load the snap-in
  • Expand Certificates > Trusted Root Certification Authorities > Certificates
  • Right-Click and select Import
  • Browse to the exported Certificate and enter the password when prompted

Retry your data source connection