Install Orchestrator from scratch using the same database

Greetings!

We need to migrate Orchestrator 21.4.2 (application and data base) from one server to another server in a new domain. We have migrated the Database, with the same name: Uipath. When installing Uipath Orchestrator 21.4.2 on a new server with a new DNS and URL name, an error occurs when connecting to an existing database:

Uploading: image.png…

Tell me how to properly install Orchestrator from scratch using the same database:

  1. Install UiPath Orchestrator 21.4.2 with new database Uipath_newDB

  2. Restore DB UiPath_oldDB_backup to DB Uipath_newDB

  3. Restore file configurations from backup (Web.config, UiPath.Orchestrator.dll.config, appsettings.Production.json - from Identity and Webhooks folder)

  4. In the config file, check\change the connection to the database, EncryptionKey, Url link, Certificate Thumbprint:

C:\Orchestrator\UiPath.Orchestrator.dll.config

<add key=“EncryptionKey” value="OLD_ENCRYPTION_KEY />

C:\Orchestrator\Identity\appsettings.Production.json

“EncryptionKey”: " OLD_ENCRYPTION_KEY "

“DefaultConnection”: “Data Source= NEW_server\RPA_UIPATH, newport;Initial Catalog= Uipath_newDB;User ID=old_user_backup;Password=old_pass_backup

“IdentityServerAddress”: “https:// NEW_URL /identity”,

“Name”: “Thumbprint NEW_Certificate

“OrchestratorUrl”: "https:// NEW_URL ",

C:\Orchestrator\Webhooks\appsettings.Production.json

“ConnectionString”: “Data Source= NEW_server\RPA_UIPATH, newport;Initial Catalog= Uipath_newDB;User ID=old_user_backup;Password=old_pass_backup

  1. Copy the Storage directory to the new server - C:\Orchestrator\Storage
  2. Change to new URL in DB tables
    identity.ClientRedirectUris
    identity.ClientPostLogoutRedirectUris
  3. Launch Orchestrator in IIS and connect Robots?

Hey!

Have a view on this docs…

Regards,
NaNi

error

Hey!

Have a view on this thread

Verify the SQL server host and make sure that it is accessible with the supplied credentials - Solution

Regards,
NaNi