Tuesday, March 20, 2012

Reporting Services Key Management

I have a situation where I need to delete the keys from my SRS install and have new ones created. I see from here: http://msdn2.microsoft.com/en-us/library/ms162822.aspx

that I can use a -s switch but I don't have that. I have this installed on SQL 2000.

Here are the options I have:

Microsoft (R) Reporting Services Key Manager
Version 8.00.1038.00 x86

Extracts from the report server and applies to the report server the key used during encryption.

RSKeyMgmt [-e] [-a] [-d] [-r installationID] [-f file] [-p password] [-t]

-e extract Extracts a key from a report server instance
-a apply Applies a key to a report server instance
-d deletecontent Deletes all encrypted content from a report server
database
-r installationID Remove the key for the specified installation ID
-f file Full path and file name to read/write key.
-p password Password used to encrypt or decrypt key.
-t trace Include trace information in error message

I don't see a way to get the new ones created, if I use rskeymgmt.exe I see ways to extract the existing and apply an extracted key but nothing about creating new keys.

Anyone know how to create new keys and apply them to an exising install?

Joe

I am not too familar with RS2000, so try this at your own risk :). You can use -d, and then -r to remove the installation from RS catalog, then restart the RS service. This should create a new key for you. However, you'll loose the encrypted content.

No comments:

Post a Comment