Reporting Serivces and Database Mirroring

[ryrae]

I am working on configuring a high availability solution for one of our reporting servers. I currently have a two node web farm configured with Reporting Serivces installed. Those servers are running Win 2003 Ent x32 with SQL 2005 Ent. x32. I also have two separate Database servers that I have setup in a mirroring auto failover with a witness. The DB servers have Win 2003 Ent. x64 and SQL 2005 Ent. x64. The failover seems to be working fine from the mirroring DB standpoint, but when it does fail over Reporting services breaks because you can only specify one server in the Reporting Services configuration. My question, is there any way to specify multiple DB servers for Reporting Services so the failover works correctly? What is my best option? I have considered setting up the Mirroring SQL DBs in a Cluster rather than Mirror, but I would rather find a solution to the current setup. Thanks for any help you can offer.

 

[mrdenny]

It appears that the SSRS source databases can't be a mirror.

http://social.msdn.microsoft.com/Fo...g/thread/30f5c7d1-a9bb-4e6d-b690-29f133affbb3

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog