Automatic Failover of SQL 2008 Reporting Server DB not possible?
Hello there,
I have set-up DB mirroring for Reporting Server DB, when the failover from Principla to Mirror occur, reporting services could not be accessed, as we have to manually change the reporting server settings?
Is this correct? OR can we automise this?
Please advise.
Thanks and Regards
Microsoft SQL Server 2008Microsoft SQL Server 2005
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!