Thursday, February 16, 2012

Change report server database

I install reporting service on 2 machines. Each RS has it's own report
server database. e.g. A_ReportServer for machine A and B_ReportServer for
machine B. Can I dynamically change the report server database ? i.e.
Machine A point to B_ReportServer database. If yes, how can I do this ?You can redirect A_ReportServer to point to Database B by running the
rsconfig.exe utility. Please refer to the following link for more
information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_7oft.asp
If your looking for load balancing or failover support as in load balancing
of the web servers or Sql Server failover that is available with the
enterprise edition. Check the BOL for more info about how to configure.
"May Liu" wrote:
> I install reporting service on 2 machines. Each RS has it's own report
> server database. e.g. A_ReportServer for machine A and B_ReportServer for
> machine B. Can I dynamically change the report server database ? i.e.
> Machine A point to B_ReportServer database. If yes, how can I do this ?

No comments:

Post a Comment