Changing SQL Port Post Installation

News Knowledge Base
,
1

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 the connection string with the custom port in the below mentioned 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 changed if Orchestrator is installed in a custom location.

  1. For this example, taking 1234 as custom port

Orchestrator - Update in UiPath.Orchestrator.dll.config

Note: If Orchestrator is enabled with Test Automation and Insights, those connection strings should update with custom port in the 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 updating the connection strings.