Migrating SQL Server Database for Privilege Manager and Secret Server Combined Installation

If you have a combined installation of Privilege Manager and Secret Server and wish to move/migrate the MS SQL Server databases, follow the steps below for the case that applies to you:

• Case I: Keeping all data in the current database: Backup the existing databases and restore them to the new SQL Server using the instructions below:

  • For Privilege Manager: see Moving the Privilege Manager DB topic below.
  • For Secret Server: Moving the Microsoft SQL Server Database to Another Machine.

  If you have successfully performed the backup and restore (per the applicable instructions above), your site will be connected to the new database.

• Case II: Abandoning all data and starting fresh:

  1. In Privilege Manager, go to https://<SERVERNAME>/Tms/Setup/Database/ConnectDatabase
  2. Provide the new database connection and click OK
  3. Install desired Delinea products like Privilege Manager and/or Secret Server.

Moving the Privilege Manager DB

Step 1: Backup and Restore the Database

1. Stop the TMS site (Ams site for Arellia) in Internet Information Server (IIS) to prevent any changes to the database
2. Stop the TMS, TMSAgent, and TMSWorker application pools (Ams and AmsWorker application pools for Arellia).
3. Back up the database by accessing SQL Management Studio and right-clicking on the database to select Tasks > Back Up.
4. Select a file location for the .bak file. Transfer this file to the new server.
5. On the new database server, through SQL Management Studio, restore the database backup (the .bak file).
6. Create and/or grant access to the account that will be accessing the database (see TMS Installation Guide for account creation instructions)

We recommend taking the old database offline.

Step 2: Connect to the new database (configure the database connection details)

1. Restart TMS website.

2. Check that the TMS, TMSAgent, and TMSWorker application pools are running.

3. Browse to your TMS URL database connection page e.g. https://<YOUR_URL_INSTANCE>/TMS/setup/database/connectdatabase (for Arellia this URL would be slightly different e.g. https://<YOUR_URL_INSTANCE>/ams/setup/database/connectdatabase) and you will see a page to enter your new database connection details.

   Note: This can only be accessed locally via the server running the Privilege Manager instance or via active RDP session into the Privilege Manager server.

4. Enter your new SQL Server and the account information.

5. Click Next and the site will connect to the new database.

Your site is now pointing to the new database.

If also migrating to new web servers or doing a reinstallation, copy the tmsEncryption.config file(s) to the new web servers(s). The file is located on the web server at the root of the TMS web site and should be copied to the same place on the destination server(s): \inetpub\wwwroot\TMS This file is only applicable if current servers are on version 10.5 or higher. (Refer to Item Encryption)

To roll back changes and restore the original database, simply start back at Step 1 and move the database back to the original database server.