Run reports on SQL 2000 databases with RS 2005?

All our databases are running on SQL 2000, with no migration to SQL
2005 planned at this time.
We do not currently use Reporting Services. A deployment of Reporting
Services 2005 is in the pipeline.
My question is, will I need to install RS 2005 on a SQL 2000 server to
be able to report on my 2000 databases? Or will it work to install RS
2005 on SQL2005 and report on SQL 2000 databases?
Thanks for helping a neophyte.The box that run RS 2005 must have a SQL Server 2005 license. You can use
SQL 2000 as the object/metadata store or you can use SQL 2005. RS reports
off of many many different types of data (SQL Server 2000, 2005, Sybase,
Oracle, etc). The does not need to and in many cases does not reside on the
same box as RS.
Even when you install RS it does not have to have the database on the same
machine(it must have a database for its object/metadata store, it just does
not have to be on the same machine) However, even if the database resides
elsewhere you have to have a license on whatever box you install RS 2005.
My preference is to have SQL Server 2005 on the box with RS even if it is
only used for RS and all the data being reported off of is elsewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>|||Yes, this will work:
"Or will it work to install RS 2005 on SQL2005 and report on SQL 2000
databases?"
Steve MunLeeuw
"xr7" <ewilson@.tpna.com> wrote in message
news:1158165177.262203.310810@.d34g2000cwd.googlegroups.com...
> All our databases are running on SQL 2000, with no migration to SQL
> 2005 planned at this time.
> We do not currently use Reporting Services. A deployment of Reporting
> Services 2005 is in the pipeline.
> My question is, will I need to install RS 2005 on a SQL 2000 server to
> be able to report on my 2000 databases? Or will it work to install RS
> 2005 on SQL2005 and report on SQL 2000 databases?
> Thanks for helping a neophyte.
>