RS2005 on SQL Server 2000 backend database

We are currently thinking about installing Reporting Services 2005 on a SQL
Server 2000 database box and allow the RS2005 instance use a SQL Server 2000
database. Are there any reasons on why we shouldn't do this?No problem whatsoever. Fully supported (I ran this way for months). Note,
you do need a SQL Server 2005 license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:F169BCBE-9784-48E9-BCA2-CEAC19211E90@.microsoft.com...
> We are currently thinking about installing Reporting Services 2005 on a
> SQL
> Server 2000 database box and allow the RS2005 instance use a SQL Server
> 2000
> database. Are there any reasons on why we shouldn't do this?|||Bruce;
I need a clarification for this.. he needs one SQL 2000 license and one
SQL 2005 license
-Aaron
Bruce L-C [MVP] wrote:
> No problem whatsoever. Fully supported (I ran this way for months). Note,
> you do need a SQL Server 2005 license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "David" <dilworth@.newsgroups.nospam> wrote in message
> news:F169BCBE-9784-48E9-BCA2-CEAC19211E90@.microsoft.com...
> > We are currently thinking about installing Reporting Services 2005 on a
> > SQL
> > Server 2000 database box and allow the RS2005 instance use a SQL Server
> > 2000
> > database. Are there any reasons on why we shouldn't do this?|||Thanks for Bruce,'s input.
Hi David,
As Bruce has mentioned, you can use both SQL Server 2000 and SQL server
2005 database as your SSRS 2005's backend database storage, this won't
affect the functionality of Reporting service since the backend database
only stores some data and settings of the Reporting service, all the
built-in components are still referenced from the SSRS 2005's installation.
Here is blog article also describes how to do this:
#Using SQL 2000 for SSRS 2005 metadata storage
http://blogs.msdn.com/bimusings/archive/2006/03/29/564173.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.sql