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:
- 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
- Set this to Yes on the IIS machine and verify.