Monday, March 12, 2012

move report server to new machine

Can someone tell me how I can move report server web sites into a new machine without reinstall it?

I like to keep the current report server database intact, it’s residing on a third server.

I copied the report server file folders including bin (dlls) into the new machine and set up in the new machine the Reportserver and Reports web sites pointing to these two folders while keeping the report server database still residing on the third machine, but the new site did not work, I got "Event source Report Server does not exist. (rsEventLogSourceNotFound)" error

Any advice will be greatly appreciated.

Thanks

Jerry

Well, the short answer is you can't. :) You'll need to install RS on the new machne. Licensing requires that if your RS and SQL are on different machines, you will need a seperate license for each.|||

Thanks James.

Well my next quest is: when I install RS on new machine with the license, I think I should install the new RS database on the same SQL server/database as the old RS server does, then will the newly installed RS DB overwrite the existing RS DB? or it will just makes use it without change anything in it?

Thanks a lot!

Jerry

|||It will never overwrite your RS database. Since you are doing a RS only install, you will only be able to use the "files-only" option (you will see this in the installation wizard). Post-install, you need to use the configuration tool to either create the RS databases, or set RS to connect to your old databases. The decision is up to you, but you will need to do it manually.|||Thanks a lot James, I will try.

No comments:

Post a Comment