Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Move a DPA repository on SQL Server

Move a DPA repository on SQL Server

Updated March 11th, 2016 


This article provides brief information and steps to move a DPA repository on a SQL Server. 

SolarWinds DPA (formerly Confio Ignite) can utilize SQL Server for the DPA Repository. (To find the supported SQL Server versions, see the system requirements in the DPA help for your version of DPA.) This article provides instructions for moving a DPA repository from one SQL Server instance to another.

If you need to move a MySQL or Oracle repository, see the following:


  • All versions of DPA


This article assumes that the target SQL Server instance is already created.  Remote Connections must be enabled to allow TCP/IP and/or Named Pipe connections.

  1. In DPA, click Stop All Monitors in the upper right to stop monitors on the current SQL Server repository.


  2. On the server, shut down the Ignite PI Server service.
  3. In SQL Server Enterprise Manager, make a backup of the repository database.  Right-click the DPA repository database, and select Tasks > Back Up.


  4. Fill out the backup page with the database name and select Full as the Backup type. Add a location and file name for the backup.


  5. Copy the backup file to the computer where the target SQL Server instance resides.
  6. In SQL Server Management Studio on the target instance, right-click the Databases menu and choose Restore Database.
  7. Enter the name of the database that was backed up in the To Database field.
  8. Choose the From device option and add the location and file name of the backup file.
  9. Select the Restore check box, and click OK.


  10. Create the DPA internal user by choosing Security > Logins > Right-Click > New Login.


  11. Choose the Server Roles page and give the new DPA user the same security privileges as the previous DPA user.


  12. On the User Mapping page, map the Repository Database to the DPA user. Give the new DPA user the same Database roles as the DPA user had in the previous repository.  Default Schema needs to be set to Ignite, and dB owner (DBO) needs to be set for that user too.


  13. Test connectivity by remotely connecting to the Repository Connection User from SQL Server Management Studio.
  14. Open the file on the DPA server with a text editor, and change the connection information.
    1. Open the file in a text editor. The file is located in the following folder:

      DPA_home\iwc\tomcat\ignite_config\idc (If your installed DPA in a Windows server, the folder should be "C:\Program Files\SolarWinds\DPA\iwc\tomcat\ignite_config\idc"

    2. Update the following values with the new repository information.

      If you have kept the same port, database name, repository connection user, and password information, you will not need to edit those fields.

      repo.databaseType=SQL Server
  15. Start the Ignite PI Server service.
  16. Ensure that all monitors start in DPA.


To investigate connectivity issues to the new server, review the idc.log and idc-errors.log files for further information. If on the new server you are getting invalid user name and password for a windows account and all test seem that the user should work such as connecting in management studio from the DPA server. Try adding this property to the file and restart the Ignite PI service. 


To report any other issues, open a technical support ticket at In preparation for your support ticket, zip up the logs directory, usually found in the following location:


Last modified