Unable to connect to the data source

When trying to connect to a Microsoft SQL Server data source in Remote Desktop Manager, you may encounter this error message:

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake."

Chances are your SQL Server is configured with a self-signed certificate that you do not have in your certificate store.

Solution

Either add the certificate to your store or configure Remote Desktop Manager to trust the certificate. Follow the steps below for the Remote Desktop Manager configuration:

  1. Select your data source in the Navigation pane.
  2. Go to File – Data Sources, then click on Edit Data Source.

File – Data Sources – Edit Data Source
File – Data Sources – Edit Data Source

  1. In the Advanced tab, click on More Settings.

Advanced – More Settings
Advanced – More Settings

  1. Scroll down to the TrustServerCertificate setting and set its Value to "true".

TrustServerCertificate = true
TrustServerCertificate = true

  1. Click OK in all the windows to save your changes, then try to connect again.
Give us Feedback