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
