?
Solved

Automatic Failover of SQL 2008  Reporting Server DB not possible?

Posted on 2011-10-03
1
Medium Priority
?
460 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:goprasad
1 Comment
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 36906648
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Screencast - Getting to Know the Pipeline
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question