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
- 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 .
- 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.