February 13, 2009 at 7:10 am
Hi,
I'm setting up mirroring in our database and we have reporting services. I want to set up the mirroring capability for reporting services database. I need to make reporting services point to a different server in case of failover. I know I have to change the DSN information in rsreportserver.config file using rsconfig utility, But I don't know the exact syntax to do this. Can someone please help?
December 1, 2009 at 6:11 am
hi,
did you get an answer to your question?
Do you know where I could find any details on how to configure SSRS mirroring and whats involved (more so from the SSRS service - I know how to mirror databases, but I'm not 100% on what I'd need to change for the service.).
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
December 11, 2009 at 9:34 am
Has anyone mirrored the reporting services database so that is can be failed over using Database mirroring
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
February 3, 2010 at 12:22 pm
I am trying to do the same thing....anybody tried?
February 7, 2010 at 12:02 pm
I've now managed to do this. I'm planning on writing an accurate on it for sql server central - hopefully Over the course of the next week or so).
a key part in the process is restoring the encryption keys...
here's another thread , to keep an eye on as there are a few others interested and I'll let you all know, once I written the article.
http://www.sqlservercentral.com/Forums/Topic843493-147-1.aspx#bm858517
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply