I’m working with a SQL Server 2012 instance that had a service master key, other secondary keys, and a SSRS key. The instance was uninstalled and reinstalled with new service accounts, and the master database was restored. No encryption keys were backed up. The original master key, now inaccessible, was left as is and the SSRS key was regenerated and backed up.
Now we need to open or regenerate the master key for SSIS use. If the SQL engine service is reset to the original login account, can the master key be opened? If so, via backup with a newly created password? If not, and the master key is regenerated, can the SSRS key be restored using its backup?
My google-fu is failing me and I want to accomplish this with the least amount of loss possible. Any pointers or assistance is greatly appreciated.