SQL 2005 Reporting Services Encryption Key issue
Posted on 2010-11-29
Our SQL Reporting Services was installed and created in 2007. We have an SSRS encryption key backup made in 2007 (an SNK file) and we are almost certain of the password that was used to create the key backup (it's 1 of a possible 3).
Since 2007 we have changed the password of the domain account that runs the SQL Reporting Service service. It has been changed 3 times. It was changed by selecting the password in AD and selecting "Reset password...". Each time, the logon properties for the service were updated with the new password and the service was restarted. The only other SSRS item that needed to be updated was the Execution Account password details in the Configuration Tool.
In the Reporting Services Configuration manager, if you try to update the password of the Windows account that runs the service, you are prompted for the location of the backed up file and "Password" (presumably this is the password used to create the snk file).
What would happen if you entered this information? What would happen if you entered the wrong password (we know it's 1 of a possible 3, but we might not get it right first time)?
If you change the password of the account that runs the service, and restart the service, and the servive works, then do you need to do anything to the key? Why are you prompted for the key password - what's going to occur when it's entered? Why bother changing the password using the Configuration manager?
(Dont know why this is in the Exchange zone, but I can't deselect that zone, my apologies)