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 server and Active directory authentication

Hi!
Does anybody know how one can prevent users from accessing some
reports on the report server website using active directory? I have an
active directory with all the users and I would like to use this to
enable / disable users from viewing and accessing reports.
Cheers ErikOn Jan 30, 1:12 am, e...@.liffner.se wrote:
> Hi!
> Does anybody know how one can prevent users from accessing some
> reports on the report server website using active directory? I have an
> active directory with all the users and I would like to use this to
> enable / disable users from viewing and accessing reports.
> Cheers Erik
Hi Erik,
You should be able to set up securtiy via the report manager website.
Permissions can be set for folders or individually for reports. If
you look at the properties and go to the security tab, you will see
the users who have permission to access the object. To start with, you
should see the user 'BUILTIN\Administrators' as Content Manager.
Here you can add new users with different roles, or create you own
roles.
Is that what you are looking for?
Rowen