Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We are moving to a scale out deployment of SSRS 2008 Enterprise with reporting services running on 2 front ends connecting to the "ReportServer" and "ReportServerTempDB" databases on a separate SQL Server 2008 cluster.

Can you run Reporting Services 2008 R2 while connected to the report server databases that live on a SQL Server 2008 (non R2) database server?

Thanks, Dan

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Yes.

Both SQL Server 2008 R2 and SDQL Server 2008 SSRS can run on a SQL Server 2005 or higher back end.

From MSDN

For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

...

SQL Server 2005 or SQL Server 2008 can be used to host the databases. Do not use SQL Server 2000 or earlier versions of SQL Server.

share|improve this answer
    
Perfect. Thank you so much. –  SQL3D Jan 24 '11 at 18:23

Your Answer

 
discard

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.