Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to migrate SQL Server 2008 Reporting Services to another computer?

April 26, 2017Computer migrate Services SQL Server

0

Posted

How to migrate SQL Server 2008 Reporting Services to another computer?

1 Answer

0

Posted

The migration process for Reporting Services includes manual and automated steps. The following tasks are part of a report server migration: 1. Back up database, application, and configuration files. 2. Back up the encryption key. 3. Install a new instance of SQL Server 2008. If you are using the same hardware, you can install SQL Server 2008 side-by-side your existing SQL Server 2000 or 2005 installation. Be aware that if you do this, you might need to install SQL Server 2008 as a named instance. 4. Move the report server database and other application files from your SQL Server 2000 or 2005 installation to your new SQL Server 2008 installation. 5. Move any custom application files to the new installation. 6. Configure the report server. 7. Edit RSReportServer.config to include any custom settings from your previous installation. 8. Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group. 9. Test your installation. 10. Remove unuse