Can Reporting Services 2005 report on SQL Server 2008 database?

we would like to upgrade our SQL Server from 2005 to 2008. Unfortunately, we also have a lot of reports based on Reporting Services 2005. If possible we would like avoid upgrading them at this time.

Is it possible to run Reporting Services 2005 of S开发者_运维问答QL Server 2008?

---

Yes.

The metadata databases for SSRS 2005 can run on SQL Server 2005 upwards. Which includes SQL Server 2008 and SQL Server 2008 R2.

Note: do not open a report in a later version of BIDS: always use BIDS 2005 in VS 2005 unless you want your reports upgraded. Then you need SSRS 2008.