Thycotic Secret Server: Moving Microsoft SQL Server Database To Another Machine

Follow the steps below for moving/migrating MS SQL Server database for Secret Server.

Backup and restore the database

  • Stop the Secret Server site in Internet Information Server (IIS) to prevent any changes to the database
  • Stop the Secret Server application pool or IIS website.
  • Back up the database by accessing SQL Management Studio and right-clicking on the database to select Tasks > Back Up.
  • Select a file location for the .bak file. Transfer this file to the new server.
  • On the new database server, through SQL Management Studio, restore the database backup (the .bak file).
  • Create and/or grant access to the account that will be accessing the database.
  • We recommend taking the old database offline.

Connect Secret Server to the new database (configure the database connection details)

  • Delete the database.config file from the secretserver folder (on the ASP.NET/IIS machine).
  • Restart your Secret Server website, so it is running.
  • Browse to your Secret Server URL and you will be prompted to enter your new database connection details.
  • Enter your new SQL Server and the account information.
  • Click Next and the site will connect to the new database.
  • Your site is now pointing the new database.

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.

To move thycotic Secret Server to another machine: Moving Secret Server To Another Machine

For more information and general guidance on our products & services, please contact us.

Require further support?

Search all Knowledgebase articles

Send a Support Request to The Idency Support Team

In good company: some of Idency's clients