How To Fix System Exception Error 1 Message "A Connection Was Successfully Established With The Server"

News Knowledge Base
, , , , ,
1

How to fix the system exception " Error 1 Message - A Connection Was Successfully Established With The Server " ?

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

System.Exception: Error:-1, Message:A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

Resolution:

  1. Add TrustServerCertificate=True to all connection strings in:
  • \uipath\orchestrator\uipath.orchestrator.dll.config
  • \uipath\orchestrator\Identity\appsettings.production.json
  • \uipath\orchestrator\Webhooks\appsettings.production.json

  1. Set this to Yes on the IIS machine and verify.

image.png


1 Like
2

Hi, we’re seeing this issue in an upgrade to 22.10 in an airgapped environment. There’s no certificate configured on the SQL server, and the installer is not allowing the upgrade to proceed as it says the certificate is not issued by a trusted certificate authority. Even after adding TrustServerCertificate=True to the connection strings above, it is still not allowing the upgrade to complete.

Step 2 we didn’t do, as there’s no SQL Server Configuration Manager installed on the “IIS Machine” (by which I presume it’s referring to the Orchestrator App Server).

So is it that with 22.10, the only way to install / upgrade 22.10 is if an SSL certificate is provisioned to encrypt traffic between the SQL server and the app server?