Changing the Orchestrator / Identity Server URL

If you decide to manually upgrade your Orchestrator instances from single node to multi-node, you may need to change the Orchestrator URL. The case where you should change the Orchestrator URL is when the load balancer URL is used in a multi-node installation, as it is independent from any node name. You also have to change Identity Server's URL.

If the single-node installation is configured to be used by a load balancer, upgrading to a multi-node installation does not require changing the public URL.

Several steps are required when changing the Orchestrator or Identity Server public address, in order to maintain Orchestrator fully functional. This page describes these steps.

Changing the Identity Server URL

For updating the Identity Server URL, follow the below SQL query:

1. Declare variables for the current server name and the new server name:

   DECLARE @CurrentServerName NVARCHAR(255) = 'server1';

   - Input: e.g. 'server1'

   DECLARE @NewServerName NVARCHAR(255) = 'server2';

   - Input: e.g. 'server2'

2. Update statement using REPLACE function:
   UPDATE [identity].[ClientRedirectUris]

   SET RedirectUri = REPLACE(RedirectUri, @CurrentServerName, @NewServerName)

   WHERE RedirectUri LIKE '%' + @CurrentServerName + '%';

   - Update only if the row contains 'server1'

   UPDATE [identity].[ClientPostLogoutRedirectUris]

   SET RedirectUri = REPLACE(RedirectUri, @CurrentServerName, @NewServerName)

   WHERE RedirectUri LIKE '%' + @CurrentServerName + '%';

   - Update only if the row contains 'server1'

Changing the Orchestrator URL

For updating the Orchestrator URL, follow the below SQL query:

1. Declare variables for the current server name and the new server name:

   DECLARE @CurrentServerName NVARCHAR(255) = 'server1';

   - Input: e.g. 'server1'

   DECLARE @NewServerName NVARCHAR(255) = 'server2';

   - Input: e.g. 'server2'

2. Update statement using REPLACE function:
   UPDATE [identity].[ClientRedirectUris]

   SET RedirectUri = REPLACE(RedirectUri, @CurrentServerName, @NewServerName)

   WHERE RedirectUri LIKE '%' + @CurrentServerName + '%';

   - Update only if the row contains 'server1'

   UPDATE [identity].[ClientPostLogoutRedirectUris]

   SET RedirectUri = REPLACE(RedirectUri, @CurrentServerName, @NewServerName)

   WHERE RedirectUri LIKE '%' + @CurrentServerName + '%';

   - Update only if the row contains 'server1'