Update Orchestrator Database Password After SQL Database Credential Password Has Been Changed

News Knowledge Base
, ,
1

How can Orchestrator database password be reset so that Orchestrator and the Orchestrator database be reconnected ?

To update the Orchestrator database with updated password either update

  • using IIS or
  • using web.config .

Approach #1: Update from IIS Manager
Steps to modify connection string for UiPath Orchestrator in IIS manager:
  1. Open IIS Manager and navigate to the UiPath Orchestrator website
  2. In Features View, double-click Connection Strings.

  1. On the Connection Strings page, select the connection string that you want to change
  2. In the Actions pane, click Edit.
1.png
  1. In the Edit Connection String dialog box, Update the password, and then click OK and restart IIS
image.png
  1. Use the below format for the SQL connection
  • Data Source=sqlserver.com;Initial Catalog=UiPath;User ID=admin;Password=●●●●●●●●●●●
Note: By updating connection string in IIS manager , that will be reflected in Orchestrator's web.config .



Approach # 2: Update from web.config
  1. Go to C:\Program Files (x86)\UiPath\Orchestrator in Orchestrator server and open web.config using Notepad or any editor
  2. Press Ctrl + F and search connectionStrings . Update the password in the same and restart IIS.
  3. Make sure no Robot is running while making above changes.
Note: In this approach, usually the password is saved in text format in web.config unless encrypted using Encrypting UiPath.Orchestrator.dll.config Sections
As the password in the web.config is shown as clear text, leading to security concerns, Approach #1 is feasible.
1 Like
2

hello,

is there any updated documentation for 2020.10+ versions since the password can’t be changed now through IIS or web.config

Thank you,

1 Like
3

Update the password in the below mentioned files:

UiPath.Orchestrator.dll.config → UiPath\Orchestrator\UiPath.Orchestrator.dll.config
appsettings.Production.json → UiPath\Orchestrator\Identity\appsettings.Production.json
appsettings.Production.json → Orchestrator\Webhooks\appsettings.Production.json

2 Likes