Multiple instances of SSRS on the same machine & encryption key management.

• Mark Kinnear

  SSC Eights!

  Points: 850

  More actions

  May 31, 2022 at 2:19 pm

  #4042110

  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.

• Jeffrey Williams

  SSC Guru

  Points: 90342

  More actions

  May 31, 2022 at 4:30 pm

  #4042162

  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