Automatic Failover of SQL 2008 Reporting Server DB not possible?
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?
Thanks and Regards
Microsoft SQL Server 2008Microsoft SQL Server 2005