RS2005 cluster-aware

I know RS2000 is nto cluster-aware.

what about RS2005....anyone knows ?

if yes, can we isntall RS2005 on the same cluster as SQL2005

Great question, does anyone know the answer to this? I need to know as well, I have a 64 bit itanium cluster.

RS2005 & Cluster

Can we install RS2005 in a Windows 2003 cluster ?SQL Server Reporting Services is an IIS application
IIS is cluster aware, so is SSRS then
Med bouchenafa
"adcoe" <adcoe@.discussions.microsoft.com> a écrit dans le message de news:
3104B222-8056-468A-AC0D-FF3FED6683FD@.microsoft.com...
> Can we install RS2005 in a Windows 2003 cluster ?
>

RS SP2 Upgrade

Hi,
We use two IIS machine hosting each an instance of Report Server. The RS
database is located on a SQL2000 SP4 cluster where no component of RS is
installed except the RS and RSTempDB databases.
We upgraded each IIS machine and the setup completed without any errors or
warning. In the release notes for SP2, it is told that the database server
needs also to be upgraded. But there are no RS components installed on the
SQL cluster and by the way nothing to upgrade.
Is this a bug on the release notes ? Is the database upgraded by the update
process on a report server machine ?
Or do I need to do anything else to upgrade the database ? How can I check
if the database was upgraded or not ?
Thanks in advance.
SBIt sounds like you have a web farm. The process of upgrading RS will upgrade
the database.
Note that you will want to upgrade your development (report designer).
Especially if you skipped SP1.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"BENHAMOU Stéphane" <BENHAMOUStphane@.discussions.microsoft.com> wrote in
message news:E26F48E0-155E-41B6-8BCF-69D4605F57BE@.microsoft.com...
> Hi,
> We use two IIS machine hosting each an instance of Report Server. The RS
> database is located on a SQL2000 SP4 cluster where no component of RS is
> installed except the RS and RSTempDB databases.
> We upgraded each IIS machine and the setup completed without any errors or
> warning. In the release notes for SP2, it is told that the database server
> needs also to be upgraded. But there are no RS components installed on the
> SQL cluster and by the way nothing to upgrade.
> Is this a bug on the release notes ? Is the database upgraded by the
> update
> process on a report server machine ?
> Or do I need to do anything else to upgrade the database ? How can I check
> if the database was upgraded or not ?
> Thanks in advance.
> SB|||Thanks for your answer.
Is there a way to check the database structure upgrade ?
I run a "select * from information_schema.columns" on an SP1 and then on the
SP2 database used by my web farm, and the number of columns is exactly the
same (206) for both versions.
Do you know what are the database structure changes ?
"Bruce L-C [MVP]" a écrit :
> It sounds like you have a web farm. The process of upgrading RS will upgrade
> the database.
> Note that you will want to upgrade your development (report designer).
> Especially if you skipped SP1.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "BENHAMOU Stéphane" <BENHAMOUStphane@.discussions.microsoft.com> wrote in
> message news:E26F48E0-155E-41B6-8BCF-69D4605F57BE@.microsoft.com...
> > Hi,
> >
> > We use two IIS machine hosting each an instance of Report Server. The RS
> > database is located on a SQL2000 SP4 cluster where no component of RS is
> > installed except the RS and RSTempDB databases.
> >
> > We upgraded each IIS machine and the setup completed without any errors or
> > warning. In the release notes for SP2, it is told that the database server
> > needs also to be upgraded. But there are no RS components installed on the
> > SQL cluster and by the way nothing to upgrade.
> >
> > Is this a bug on the release notes ? Is the database upgraded by the
> > update
> > process on a report server machine ?
> >
> > Or do I need to do anything else to upgrade the database ? How can I check
> > if the database was upgraded or not ?
> >
> > Thanks in advance.
> > SB
>
>

RS on MS Cluster Active/Passive configuration

I have insatalled RS onto an Active Passive SQL Server with IIS installed on
the cluster
as well. I have configured RS on two node work with the same ReportServer
database.
I have moved virtual directory to Shared store...
And now I can run reports on localhost on two nodes,but from Shared store RS
works
only,when Node 1 is active.Then Node 2 is active i get error message :
The encrypted value for configuration setting Dsn cannot be decrypted.
(rsFailedToDecryptConfigInformation) Get Online Help
An internal error occurred on the report server. See the error log for more
details.
(rsInternalError) Get Online Help
My configuration :
MS cluster Active/Passive Windows 2003
SQL 2000 Enterprise + SP3a + Fix 859
RS enterprise + SP1
Any help and guidance in this arena would be appreciated. Thanks.oleg,
It appears that installing RS on an active passive cluster where both
instances of IIS use the same data store it not possible. The reason
is that the DSN information is encrypted per machine and is unique to
the machine. I tried to get luck and synch up the machine keys on the
memebers in the cluster but even after they were synched up, it was
still not possible to get it working. What I have opted to do instead
is to allow each instance of IIS (default web) in the A/P cluster to
respond to the name of the SQLCluster name. When I fail from one box
to the other I am still able to serve up the other version of reporting
services. So while I am not NLB'ing the cluster I am still able to
server two instances of RS. Best idea I have had so far. I am
researching into getting both machines to use the same encryption
algorythm.
Hope that helps.
oleg wrote:
> I have insatalled RS onto an Active Passive SQL Server with IIS
installed on
> the cluster
> as well. I have configured RS on two node work with the same
ReportServer
> database.
> I have moved virtual directory to Shared store...
> And now I can run reports on localhost on two nodes,but from Shared
store RS
> works
> only,when Node 1 is active.Then Node 2 is active i get error message
:
> The encrypted value for configuration setting Dsn cannot be
decrypted.
> (rsFailedToDecryptConfigInformation) Get Online Help
> An internal error occurred on the report server. See the error log
for more
> details.
> (rsInternalError) Get Online Help
> My configuration :
> MS cluster Active/Passive Windows 2003
> SQL 2000 Enterprise + SP3a + Fix 859
> RS enterprise + SP1
> Any help and guidance in this arena would be appreciated. Thanks.