How can one use Reporting Services against a log shipped database?

Question

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it complains about the ReportServer database being Read Only.

Is there some way of doing this?

Answer 1

You can do this in SQL 2005 Enterprise Edition. This may be a limitation of pricing and fees to honor that functionality.

Answer 2

you'd better of replicating the database you want to report on, that should work in any version. It can be a bit of a pain to setup but once you have set it up its very reliable, and should work on any version (apart from probably sql express)