motto
Reputation: 1306
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 SQL Server 2008?
Upvotes: 1
Views: 2732
Answers (1)
gbn
Reputation: 432261
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.
Upvotes: 3
Related Questions
- Can I use SSRS 2008 R2 with a SQL Server 2008 database?
- Can SSRS 2008 be used to report on SqlServer 2005 data, and if so is this a good idea?
- SSRS report 2005 in VS2010
- Reporting services 2008 on Sql Server 2005
- SQL Server Reporting Service(SSRS) 2005 reports on SSRS 2008
- Can I display SSRS 2008 reports in a .Net 2 website?
- can i run my reports developed in using ssrs 2008 on ssrs 2000
- SSRS 2008 Reporting Services on SQL Server 2005
- SSRS Report Builder 2.0 - Use with SQL 2005
- Can Reporting Services 2008 be used with SQL Server 2005 as the catalog database?