I have the following error when running reports: “The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database.” How can I run reports?
To resolve this issue open the Reporting Services Configuration on the PC/Server with OPTAC3 installed on it. This can be found in Start, Programs, Microsoft SQL Server 2005. In this screen click on Connect and then Encryption Keys. Click on Restore and type in the password ‘Stoneridge1’ and browse to the file ‘optac3rskey.snk’ located in C:\Program Files\Stoneridge\OPTAC3\Reports. Click OK and the key will be restored and reports will now work.