While Trying To Enable UiPath Insight Feature For Orchestrator tenant Error "error occurred while establishing connection to sql server" Thrown

How to resolve when while trying to enable UiPath Insight feature for Orchestrator tenant , an error "error occurred while establishing connection to sql server" is encountered?

Issue Description: While trying to enable UiPath Insight feature for Orchestrator tenant , an error comes "error occurred while establishing connection to sql server"



Resolution:

  1. The connection string for connecting to UiPath Insights database might not be right.
  2. To validate the connection string , go to the location - C:\Program Files (x86)\UiPath\Orchestrator\Tools\UiPathAdminTool.config file. and search for connection string. It would show two entries one for "Orchestrator" and the other for "Insights"
  3. Focus on "Insights" and validate the connection string if its correct or not
  4. In case it is wrong, updating the connection string is required. In order to update the connection string, follow the command shared below using the UiPathAdminTool.exe
SQL Auth
.\UiPath.InsightsAdminTool.exe updateDB -u admin -p Orch_Host_Password -c Default -s sql.uipath.com -n UiPathOrchestrator -r docs-uipath -w my_SQL_Password
Windows Auth
.\UiPath.InsightsAdminTool.exe updateDB -u admin -p Orch_Host_Password -c Default -s sql.uipath.com -n UiPathOrchestrator -a true

For more information visit Running The Insights Installer .