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