sql server reporting services: 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.

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.



[quoted text, click to view]