How to Change User Details for Connecting to the Database in Orchestrator

How to change the password of a SQL user in Orchestrator?

Starting from version 2020, the password to connect to the database is stored at multiple places in Orchestrator server. 

  1. Password needs to be manually modified at below places:
  • web.config file / orchestrator.dll.config file based on the version of Orchestrator. This file can be found inside installation folder of Orchestrator.
  • appsettings.production.json inside identity folder 
  • appsettings.production.json inside webhook folder 
  1. Restart IIS by running IISRESET command, in the command prompt opened in elevated mode.