goprasad
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.