Change Report Server Primary Database

English Forum
1

I would like to migrate the database that the report server uses to store user information, settings, reports, etc to a new database server. Is this possible?

2

Hello Chris.

You can proceed as follows:

  • Create a backup of the database to be migrated.
  • Import to the new server.

Important: Please note that the database on the system to be imported must always have the name combitReportServer. It is currently not possible to change the name of the database.

  • Open the configuration file C:\Program Files\combit\combit Report Server\WebUI\privateSettings.config as administrator, e.g., in a text editor.

  • Set the value for the key IsDbReady to false: <setting key="IsDbReady">false</setting> and save.

  • Restart IIS (e.g., enter iisreset via a command line with elevated rights and confirm).

The next time the ReportServer is called up, the setup wizard appears, and the ‘new’ database connection can be specified and saved. The database is not overwritten during this setup process. The database will be recognized and can be used. However, it is recommended to keep a backup copy of the database.

  • The new connection to the database server can be verified in the Report Server Menu under Management > Advanced Settings.

I hope this helps. I would appreciate some feedback on whether it worked
(smoothly :smiley:).

3

perfect, I will give it a try this weekend

4

That worked great thank you.

2 Likes