question

Blackhawk-17 avatar image
Blackhawk-17 asked

Removing Keys From Report Server

HELP!!!

I have a four node failover cluster.

Our thought was, even though we are running Standard Edition, that if we failover Reporting Services we could just use RSKeyMgmt.exe to remove the key and restore the "real" one.

This seemed to have worked in early testing.

Now when we fail over we see four different keys using the -L parameter.

The -R switch sometimes removes an entry but when we try and remove another all four are there again.

I have even tried deleting the entries from the Keys table itslef but they automagically reappear.

Even after deleting numerous times via SQL when I run Reporting Services Configuration Manager and run through Database Setup all goes well except for a warning on:

Setting Connection Info for Reporting Server

You specified a connection to a report server database that contains encryption keys for another report server. If you are configuring a scale-out deployment, that feature is not supported by this edition of Reporting Services. If you want to use this report server database with the current report server instance, remove the existing encryption keys first.

The worst part of all this is that the instance had failed over for maintenance reboots and then been failed baack. It is actually running on the same physical node it has been on for the last year.

Any suggestions out there?

sql-server-2005ssrsmaintenancefailover
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Pavel Pawlowski avatar image
Pavel Pawlowski answered

If you have running several instances of SSRS and they are configured against a single database (you can do this even in standard edition ans you will see warning you mentioned). then when you delete a key from the Keys table a new one is automatically created if the node is running.

You can have only one configured and running instance against a SSRS database for Standard edition.

It is possible to setup the fail over even in the standard edition using replication and some workarounds.

I've made such setup with 3 nodes about half a year ago and ti's running well.

I have description of this here : http://pavel-pawlowski.spaces.live.com/blog/cns!BDEF45F53396AD8E!3703.entry

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.