How to find SQL Server connection credentials of Orchestrator database?

How to find SQL Server connection credentials of Orchestrator database?

This situation arises when the person managing Orchestrator does not have the visibility of the credentials used for Orchestrator application to connect with it's database.
 

To fetch the credentials, please login to the server where Orchestrator is installed and navigate to the installation directory (by default, C:\Program Files (x86)\UiPath\Orchestrator). Open the web.config in Notepad or Notepad++ and search for ConnectionStrings. You will be able to see SQL Server connection string inside that XML element.



Please note if the credentials are not present, and if "IntegratedSecurity" is set to true, then Orchestrator is using Windows Authentication to login into SQL Server.This would mean one can open SQL Server Management Studio on the windows profile configured for the Application pool user and login using Windows Authentication option without providing any credentials. Please see below screen shot - 
Image_2020-02-24_13-23-50.png


If the username and password is present in the web.config, then Orchestrator is using a dedicated SQL Server account to login into SQL Server. In this case, the SQL Server Authentication would have to be selected and the credentials from web.config will have to be provided for login. Please see below screen shot - 
Image_2020-02-24_13-25-44.png