Reporting Services 2003 and 2005 on same server?

Can I install Reporting Serer 2005 and 2003 on the same server, each 1
accessing a seperate SQL2000 database?
Are there any white papers on this regard?
ThanksCan you clarify the versions;
I assume you mean RS2000 (there isn't a 2003).
Also what do you mean by 'accessing a SQL2000 database'.
The RS2000 needs to reside in a SQL2000 db, but it can access any OLE
DB compliant datasource.
Likewise, RS2005 needs to reside in a SQL2005 db, but again it can
access any OLE DB compliant datasource (including SQL2000).
RS2005 will not work installed on a SQL2000 only server.
I don't know whether RS2000 will work from within 2005 and I don't know
why you would try?
SQL2005 is still beta, if you are trying to run it alongside a live
RS2000 implementation on the same server I would advise you strongly
not to!
If you are testing both of these, then maybe consider Virtual PC or
Virtual Server, this is a safe way of testing different things on one
machine.
Go here for white papers and all things SQL2005 from Microsoft;
http://www.microsoft.com/sql/2005/
Regards
Chris
Hennie wrote:
> Can I install Reporting Serer 2005 and 2003 on the same server, each
> 1 accessing a seperate SQL2000 database?
> Are there any white papers on this regard?
> Thanks|||Just a quick comment. At release RS 2005 is supposed to be able to install
using a SQL Server 2000 database. You still have to have a 2005 license
though.I don't know if the beta will do this or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:%233DX0$YnFHA.3628@.TK2MSFTNGP10.phx.gbl...
> Can you clarify the versions;
> I assume you mean RS2000 (there isn't a 2003).
> Also what do you mean by 'accessing a SQL2000 database'.
> The RS2000 needs to reside in a SQL2000 db, but it can access any OLE
> DB compliant datasource.
> Likewise, RS2005 needs to reside in a SQL2005 db, but again it can
> access any OLE DB compliant datasource (including SQL2000).
> RS2005 will not work installed on a SQL2000 only server.
> I don't know whether RS2000 will work from within 2005 and I don't know
> why you would try?
> SQL2005 is still beta, if you are trying to run it alongside a live
> RS2000 implementation on the same server I would advise you strongly
> not to!
> If you are testing both of these, then maybe consider Virtual PC or
> Virtual Server, this is a safe way of testing different things on one
> machine.
> Go here for white papers and all things SQL2005 from Microsoft;
> http://www.microsoft.com/sql/2005/
> Regards
> Chris
> Hennie wrote:
>> Can I install Reporting Serer 2005 and 2003 on the same server, each
>> 1 accessing a seperate SQL2000 database?
>> Are there any white papers on this regard?
>> Thanks
>

reporting services

Hi, quick question...
Can I use SQL2000 reporting services with MSDE 8.00.760(SP3)?
Tks
JFB
I believe that you can run reports against an MSDE database, but Reporting
Services itself uses SQL Server to store metadata and cannot be installed on
MSDE. The system requirements are listed at
http://www.microsoft.com/sql/reporti...fo/sysreqs.asp and do not
include MSDE.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"JFB" <jfb@.newSQL.com> wrote in message
news:OJb2BMVVEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi, quick question...
> Can I use SQL2000 reporting services with MSDE 8.00.760(SP3)?
> Tks
> JFB
>
|||Tks for reply Stephen.. I will upgrade to sql2000 server
JFB
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O2zq1yVVEHA.3380@.TK2MSFTNGP11.phx.gbl...
> I believe that you can run reports against an MSDE database, but Reporting
> Services itself uses SQL Server to store metadata and cannot be installed
on
> MSDE. The system requirements are listed at
> http://www.microsoft.com/sql/reporti...fo/sysreqs.asp and do not
> include MSDE.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "JFB" <jfb@.newSQL.com> wrote in message
> news:OJb2BMVVEHA.2520@.TK2MSFTNGP12.phx.gbl...
>
|||Reporting Services can indeed draw data from any data source including any
version of MSDE. However it must be hosted on a SQL Server 2000 Standard
Edition (or better). We discuss these issues in our new book. See
www.sqlreportingservices.net for more information and two chapters to
download.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O2zq1yVVEHA.3380@.TK2MSFTNGP11.phx.gbl...
> I believe that you can run reports against an MSDE database, but Reporting
> Services itself uses SQL Server to store metadata and cannot be installed
on
> MSDE. The system requirements are listed at
> http://www.microsoft.com/sql/reporti...fo/sysreqs.asp and do not
> include MSDE.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "JFB" <jfb@.newSQL.com> wrote in message
> news:OJb2BMVVEHA.2520@.TK2MSFTNGP12.phx.gbl...
>