The first thing I would ask is if this is a fresh system or are you restoring the Reporting Database from a backup. If it's a completely new install does the login have the permissions it needs? What do you see in the event viewer anything different than you've listed? I changed the account password and updated the service run password to match. It worked for a while but eventually ran into the same problem so I changed the service to runto localservice.
I appreciate the suggestions. I am taking a look at them now and found that the accounts running the database where not in the administrators group. They are now. I switched the services back from localservice to run with the local accounts. Taking a look at the Reporting Services Configuration Manager I noticed the encryption Keys and ran a backup which failed.
You perform these tasks in response to a specific threat to your report server, or as a last resort when you can no longer access a report server database. Extracts, restores, creates, and deletes the symmetric key used to protect sensitive report server data against unauthorized access.
This utility is also used to join report server instances in a scale-out deployment. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.
Privacy policy. This article helps you resolve the problem that occurs when you reset Report Server service account.
When you work with a computer that is running Microsoft SQL Server, you may receive the following error message in the Report Server service trace log:. An internal error occurred on the report server.
See the error log for more details. Additionally, you may receive the following error message in the Report Server service trace log:. Last Published: Ratings: 0 0. Product s : Enterprise Vault. Problem When trying to access the Report Server page the error below is generated: Error Message The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database.
Under the Encryption Keys section, click the delete button. Under Configuration Options, click on Reconfigure data access settings for Reporting. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science.
Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 8. Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.
0コメント