Can RS 2005 point to SQL 2000 DB?

I would like to install Reporting Services 2005 on one IIS box and point to a
separate SQL Server 2000 box which would be used to host its two databases
(ReportingServer and ReportingServerTempDB).
Will this work?
--
LulkYes. You need a 2005 license on the IIS box but the databases can be on 2000
(I am running in this configuration).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Yes, this will work. The database will have to have its schema updated, but
can be hosted on SQL Server 2000. You can use the Reporting Services
Configuration Tool to accomplish this easily enough.
Rodney
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>I would like to install Reporting Services 2005 on one IIS box and point to
>a
> separate SQL Server 2000 box which would be used to host its two databases
> (ReportingServer and ReportingServerTempDB).
> Will this work?
> --
> Lulk|||Does it require two SQL Server licenses if you are going to run RS 2005 on a
separate ISS server and point to a separate 2000 SQL Server? What if I point
to a separate SQL 2005 Server, would that configuration still require two SQL
Server licenses?
--
Lulk
"Bruce L-C [MVP]" wrote:
> Yes. You need a 2005 license on the IIS box but the databases can be on 2000
> (I am running in this configuration).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
> >I would like to install Reporting Services 2005 on one IIS box and point to
> >a
> > separate SQL Server 2000 box which would be used to host its two databases
> > (ReportingServer and ReportingServerTempDB).
> >
> > Will this work?
> > --
> > Lulk
>
>|||Yes. Whatever box RS is running on needs a license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lulk" <Lulk@.discussions.microsoft.com> wrote in message
news:3A86DA3A-674D-4F8E-BAF2-9CB0823DEF9A@.microsoft.com...
> Does it require two SQL Server licenses if you are going to run RS 2005 on
> a
> separate ISS server and point to a separate 2000 SQL Server? What if I
> point
> to a separate SQL 2005 Server, would that configuration still require two
> SQL
> Server licenses?
> --
> Lulk
>
> "Bruce L-C [MVP]" wrote:
>> Yes. You need a 2005 license on the IIS box but the databases can be on
>> 2000
>> (I am running in this configuration).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Lulk" <Lulk@.discussions.microsoft.com> wrote in message
>> news:E9845796-C306-4014-B9D2-6C753C4F2EA5@.microsoft.com...
>> >I would like to install Reporting Services 2005 on one IIS box and point
>> >to
>> >a
>> > separate SQL Server 2000 box which would be used to host its two
>> > databases
>> > (ReportingServer and ReportingServerTempDB).
>> >
>> > Will this work?
>> > --
>> > Lulk
>>