May 31, 2022 at 2:19 pm
Hi Everyone.<br /><br />It recently became a need to install a second instance of SSRS on one of our SQL servers.<br />Wasn't too tricky to get in and working. The part that i have not been able to figure out yet is the encryption key management.<br />I backup the encryption key daily to our backup staging server. Its done using a simple batch file that echo's to a location.. Like so..<br /><br />echo y |RSKEYMGMT -e -f <<NetworkPath>>/ReportServerKey.snk -p <<Password>> <br /><br />Its fine for a single instance of SSRS running on the machine. How do I manage the additional encryption key for the instance i have just loaded?
<br />Any input would be greatly appreciated.
May 31, 2022 at 4:30 pm
FYI - as of SSRS 2017 you cannot install multiple instances of Reporting Services on a single machine. Instead of trying to figure out how to manage encryption keys for multiple instances you really need to uninstall that second instance - and upgrade to the latest version of SSRS.
If you need multiple instances of SSRS - then you will need multiple servers to support each instance. With that said - there really is no need to have a second instance since you can control all access to reports through folder management and security in SSRS.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply