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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment