How To Use SQL Server Multi-Subnet Failover As Orchestrator Database

How to use SQL server multi-subnet failover as Orchestrator database?

UiPath supports SQL Server multi-subnet failure and in order to enable it, parameter "MultiSubnetFailover=True" should be added to the connection string.

Below are the steps to modify the connection string based on Orchestrator Version.

For Orchestrator version 2020.4 & earlier :

The Orchestrator should be pointed to the SQL AOAG Listener. Updating Web.config file

  1. Open Web.config file using notepad or notepad++ from the Orchestrator installation director. Default location will be "C:\Program Files (x86)\UiPath\Orchestrator\Web.config"
  2. Add "MultiSubnetFailover=True" parameter under the connection string as shown below
    • <connectionStrings> 
      <add name="Default" providerName="System.Data.SqlClient" connectionString="Server=sql;Database=UiPath;User ID=uipath;Password=password;MultiSubnetFailover=True;" /> 
      </connectionStrings> </pre>
      
  3. Save the changes and perform an 'IISRESET' from the command prompt.


For Orchestrator version 2020.10 & higher:

The Orchestrator should be pointed to the SQL AOAG Listener. Updating Orchestrator.dll.config file
  1. Open Orchestrator.dll.config file using notepad or notepad++ from the Orchestrator installation director. Default location will be "C:\Program Files (x86)\UiPath\Orchestrator\UiPath.Orchestrator.dll.config"
  2. Add "MultiSubnetFailover=True" parameter under the connection string as shown below
    • <connectionStrings> 
      <add name="Default" providerName="System.Data.SqlClient" connectionString="Server=sql;Database=UiPath;User ID=uipath;Password=password;MultiSubnetFailover=True;" /> 
      </connectionStrings> 
      


Updating appsettings.Production.json file for Identity
  1. Open appsettings.Production.json file using notepad or notepad++ from the Orchestrator installation director. Default location will be "C:\Program Files (x86)\UiPath\Orchestrator\Identity\appsettings.Production.json"
  2. Add "MultiSubnetFailover=True" parameter under the connection string as shown below
    • <connectionStrings> 
      <add name="Default" providerName="System.Data.SqlClient" connectionString="Server=sql;Database=UiPath;User ID=uipath;Password=password;MultiSubnetFailover=True;" /> 
      </connectionStrings> 
      
Updating appsettings.Production.json file for Webhooks
  1. Open appsettings.Production.json file using notepad or notepad++ from the Orchestrator installation director. Default location will be "C:\Program Files (x86)\UiPath\Orchestrator\Webhooks\appsettings.Production.json"
  2. Add "MultiSubnetFailover=True" parameter under the connection string as shown below
    • <connectionStrings> 
      <add name="Default" providerName="System.Data.SqlClient" connectionString="Server=sql;Database=UiPath;User ID=uipath;Password=password;MultiSubnetFailover=True;" /> 
      </connectionStrings> 
      
  3. Save the changes and perform an 'IISRESET' from the command prompt.

where is the connection string in the post? It’s empty.

Hello! There seems to be a sync issue with the Forum version of this article, unfortunately.

Please try the link below:
https://uipath.my.salesforce-sites.com/CaseView/articles/Knowledge/How-to-use-sql-server-multi-subnet-failover-as-Orchestrator-database?lang=en_US