Move Reporting server database instance from one server to another in SQL Server

Following the steps below to Move Reporting server database instance from one server to another in SQL Server 2005,2008,2012 etc

1. Take the backup report server and report server temp db and restore in another server. ( if you want to move db also)
2. In the new server open reporting service configuration manage and re configure with new server details and start again.
3. Remove the encryption keys .
Then reports will work from new server.

Comments