Change SQL Credential For Existing Orchestrator

News Knowledge Base
, , , , , , , , , , ,
1

How to encrypt the SQL credential in the config file, while changing the SQL-server credential in the existing Orchestrator?

Resolution: Perform the below steps

  1. Make sure that the new credential has db_owner privilege on all the UiPath-DBs. If db_owner is not allowed, then ensure that the user is setup as per the instruction in the Prerequisites of the SQL Server Installation .
  2. Change the below config files such that they reflect the new username/credential info:

C:\Program Files (x86)\UiPath\Orchestrator : UiPath.Orchestrator.dll.config

C:\Program Files (x86)\UiPath\Orchestrator\Identity : appsettings.Production.json

C:\Program Files (x86)\UiPath\Orchestrator\Webhooks : appsettings.Production.json

Note: Please take a backup of files before making changes.

Also, encrypt the details in the configuration file by following the guidelines in the example of Encrypting the Secureappsettings section.