A Connection Was Successfully Established With The Server But An Error Occurred During The Pre-Login Handshake

News Knowledge Base
,
1

Upgrade from 2019.10.14 to 2022.4.4 fails with an error occurred during the pre-login handshake.

Issue Description: On running the msi installer for Orchestrator 2022.4.4 to Upgrade from 2019.10.14, the following error appears:

System.Exception: Error:-70, Message:An error has occurred while installing the database. Microsoft.Data.SqlClient.SqlException (0x80131904): 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.)

Resolution:

  1. As DB is in AOAG, parameter need to be passed to connection string: MultiSubnetFailover=True
  2. Even after passing the parameter upgrade may fail with same error.
  • Workaround for this is, Instead of using AOAG Listener, connection string in web.config can be changed to point directly to Primary DB.
  1. Perform the upgrade
  2. Change connection string to use AOAG Listener in:
  • UiPath.Orchestrator.dll.config
  • Identity\appsettings.Production.json
  • Webhooks\appsettings.Production.json

  1. Restart from cmd > iisreset .