We want to install SQL Server Reporting Services 2008 on Server "A" which is not clustered. We want to use Server B to host the Reporting Services databases. Server B is a SQL 2005 cluster in Active/Passive mode. Any reason why this shouldn't work?

We don't have a good test environment for this, otherwise we'd just try it.


  • 1
    Watch out for licensing. Unfortunately, the SSRS 2008 server will require a SQL Server license. – Rob Boek Jun 4 '09 at 4:36

Yes you can use SQL 2005 backend for SSRS 2008. Quote:

You can use an instance of the Database Engine from SQL Server 2005 or SQL Server 2008 to host the databases.

In the olden days, you could not host SSRS 2005 databases onto SQL Server 2000.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.