Removing Keys From Report Server


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?

more ▼

asked Jan 14, 2010 at 10:56 AM in Default

avatar image

12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Jan 14, 2010 at 11:55 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 14, 2010 at 10:56 AM

Seen: 3035 times

Last Updated: Jan 14, 2010 at 10:56 AM

Copyright 2018 Redgate Software. Privacy Policy