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:
- The connection string for connecting to UiPath Insights database might not be right.
- 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"
- Focus on "Insights" and validate the connection string if its correct or not
- 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
.\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
.\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 .