Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
Watch out for licensing. Unfortunately, the SSRS 2008 server will require a SQL Server license. – Rob Boek Jun 4 '09 at 4:36
up vote 2 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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