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