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.