000038447 - Migrate RSA Archer to a new SQL database server without creating a new config database

Document created by RSA Customer Support Employee on Apr 6, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038447
Applies ToRSA Archer all versions
IssueNew SQL servers are created for an existing Archer environment. The rest of the Archer environment is to remain on their original servers. This is a high level set of instructions and the user is expected to use the installation guide for their current Archer version.
Resolution

Export X509 certificate from Archer web server



  1. Log into an Archer web server
  2. Open the web.config file in Notepad.
  3. Identify the defaultCertificate name then close web.config
    • User-added image
  4. Open the cert store and export that certificate with a private key.
  5. This will be used on all servers, place a copy on all Archer servers or a share accessible to all servers.

Prepare the Archer environment



  1. Open the Archer Control Panel.
  2. Open the Job Engine Manager plugin.
  3. Select the Servers tab and discontinue Job Processing for all job servers.
  4. Wait all jobs to complete.
  5. Exit the Archer Control Panel.
  6. Stop all Archer services on all Archer servers. This includes the Configuration service.
  7. Stop IIS on all Archer web servers (IISRESET /stop).


SQL Server preparation



  1. Back up both the Configuration and Instance databases from the original SQL Server
  2. Restore both DBs to the new SQL Server.
    • The restored DBs maintain their original DB compatibility level. If you migrated from SQL 2014 or lower to SQL 2016 and intend to install Archer 6.5 or higher, you must change the compatibility level prior to installing the newer version of Archer.
  3. Set up the SQL server according to the installation guide for the current version of Archer (see “Preparing the Database Servers”.)


Limited Archer installation



  1. A limited Archer installation of the current version of Archer must be run on all Archer servers.
  2. In the Installation Options window of the installer, choose the following options:
    • On servers that run Advanced Workflow, choose both Services and Advanced Workflow options.
    • On servers that run services, choose only the Services option.
       
  3. In the Choose Certificate window, select “Use a different certificate” then [Next].
  4. In the Specify Certificate window, select the “Select from disk” and point to the certificate you exported in the previous section above. This is the certificate that was used to encrypt entries in the databases.
  5. In the Configuration Database Options and Instance Database Options windows (not shown), point to the new SQL server and set the options according to your requirements (integrated security, login name, so forth)
  6. Complete the rest of the installation; see the Installation Guide of your current version for specific details if needed.

Attachments

    Outcomes