How To Find SQL Server Connection Credentials Of Orchestrator Database?

[system]

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

To fetch the credentials, 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 ( if 20.4 or lower Orchestrator Version is present) or Uipath.Orchestrator.DLL.config ( if 20.10 or higher Orchestrator Version is present) in Notepad or Notepad++ and search for ConnectionStrings. It is possible to see SQL Server connection string inside that XML element.

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 indicates the possibility to 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.
See below screen shot

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 as seen below,