Hi, We have a production default sql server 2000 instance database engine along with reporting services installed on the same same server.The reort server and reportservertempDb also on the same default instance.Now, we need to move this entire database engine and reporting services to ServerB(SQL server 2000).To achive this, we installed New sql server 2000 default instance on serverB and moved all the databases,logins,jobs.Now How to move the reporting services to serverB from production server? I did not find any document for this task to achive. Could you please put steps together to do this task? thanks
Welcome to the forums. The following links from Books online should help you: How to: Migrate a Reporting Services Installation Moving the Report Server Databases to Another Computer
Thank You, Here one thing I did not understand. Please clarify me. In ServerB, do we need to install the reporting services or not?
i followed the above links and I did the following 1.Install reporting services in New server. 2.Delete the ReportServer n ReportServerTempDb and restored the ReportServer n ReportServerTempDb from Old Server. 3.run the following command at a command prompt on the computer that is configured as the report server: RSConfig -c -s Server name -d Reporting Services database name -a Sql|Windows -u User name -p User password 4.Backup the encryption key in old server using RSKeyMgmt.exe -e -f Path of file name -p Strong password 5.Stop the IIS in new server 6.Restore the encryption key in new server that we have backed up in old server 7.Start the IIS 8.Then i went to the IIS->default website->reports->browse, I got the below error This edition of Reporting Services does not support web farm deployment. (rsInvalidRSEditionConfiguration We are using Reporting services 2000 standard edition. what are the steps do I need follow to accomplish this?