Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Services in mirroring Expand / Collapse
Author
Message
Posted Friday, February 13, 2009 7:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 8, 2011 9:47 AM
Points: 95, Visits: 158
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?
Post #656547
Posted Tuesday, December 1, 2009 6:11 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:38 AM
Points: 405, Visits: 1,136
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)
Post #826593
Posted Friday, December 11, 2009 9:34 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:38 AM
Points: 405, Visits: 1,136
Has anyone mirrored the reporting services database so that is can be failed over using Database mirroring

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #833033
Posted Wednesday, February 3, 2010 12:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:24 AM
Points: 41, Visits: 512
I am trying to do the same thing....anybody tried?
Post #858929
Posted Sunday, February 7, 2010 12:02 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:38 AM
Points: 405, Visits: 1,136
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)
Post #861363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse