troubleshooting Question

Problems with Encryption Keys in Report Server

Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)Flag for United States of America asked on
DB Reporting ToolsMicrosoft SharePointMicrosoft SQL Server 2005
1 Comment1 Solution2143 ViewsLast Modified:
i am trying to integrate sql report server with MOSS 2007.  in the process of trying to get the integration to work, it seems that i have messed something up with the encryption keys.

when i  go to Encryption Keys in the Reporting Services Config Manager, the Backup and Change buttons are disabled.  Restore and Delete are not disabled.  I have tried using Restore and pointing it to my backup of the encryption keys, but it fails
"The encrypted value for the "LogonCred" configuration setting cannot be decrypted"

if i click the Delete button, nothing happens.

i have tried following these instructions for re-creating the keys:

but i'm stuck here:
"a.  Start the SQL Server Surface Area Configuration tool and click Surface Area Configuration for Features.
b. Select Reporting Services.
c. For Web Service and HTTP Access, clear the checkbox Enable Web Service and HTTP Access."

because i do not see "Reporting Services" in the Surface Area Config for Features.

how do i resolve this issue?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros