Changing SQL Port Post Installation

How to change the custom port for SQL after installation of Orchestrator?

Perform the below steps to configure Custom Port for SQL

  1. Update the Data Source value in connection string with the custom port in mentioned below files
  • UiPath.Orchestrator.dll.config - C:\Program Files (x86)\UiPath\Orchestrator - (1 connection string it may change if Test Automation and insights enabled )
  • appsettings.production.json - C:\Program Files (x86)\UiPath\Orchestrator\Identity - (1 connection string)
  • appsettings.production.json - C:\Program Files (x86)\UiPath\Orchestrator\Webhooks - (2 connection strings)

Note: Locations may get change if Orchestrator is installed in custom location.

  1. For this example, taking 1234 as custom port

Orchestrator - Update in UiPath.Orchestrator.dll.config

<add name="Default" providerName="System.Data.SqlClient" connectionString="Data Source=XXXXXXX,1234;Initial Catalog=xxxx;User ID=xxxxx;Password=xxxxx" />

Note: If Orchestrator is enabled with Test Automation and Insights, those connection strings should update with custom port in same UiPath.Orchestrator.dll.config file

  1. Identity - Update in appsettings.production.json

"ConnectionStrings": {

"DefaultConnection": "Data Source=XXXXXXX,1234;Initial Catalog=xxxx;User ID=xxxxx;Password=xxxxx"

}

Webhooks - Update in appsettings.production.json

{

"OrchestratorSqlClientSettings": {

"ConnectionString": "Data Source=XXXXXXX,1234;Initial Catalog=xxxx;User ID=xxxxx;Password=xxxxx"

},

"LedgerConfiguration": {

"Subscribers": [

{

"ConnectionString": "Data Source=XXXXXXX,1234;Initial Catalog=xxxx;User ID=xxxxx;Password=xxxxx"

}

]

},

"WebhookServiceConfig": {}

}

Note: Please take the backup of the above 3 files before update the connection strings