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

How to use SQL server multi-subnet failover to connect with the Orchestrator database?

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

Below are the steps to modify the connection string based on the 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
    •  
       
       
  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
    •  
       
       


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
    •  
       
       
      
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
    •  
       
       
      
  3. Save the changes and perform an 'IISRESET' from the command prompt.
Note: Please note that there will be 2 instances of the Connection Strings in this file, so make sure to modify both before resetting the IIS.

Updating appsettings.Production.json file for Resource Catalog
  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\ResourceCatalog\appsettings.Production.json"
  2. Add "MultiSubnetFailover=True" parameter under the connection string as shown below
    •  
       
       
      
  3. Save the changes and perform an 'IISRESET' from the command prompt.
Note: Please note that there will be 2 instances of the Connection Strings in this file, so make sure to modify both before resetting the IIS.

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