Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Reporting Services Error - rsAccessDeniedToSecureData

Posted on 2007-11-29
3
Medium Priority
?
5,316 Views
Last Modified: 2013-11-06
We had some kind of update pushed out to our environment last night and our application took a pretty good hit.  Got almost everything cleaned up but this last error is dug in.  On our home page we have a SQL Reporting Services report but instead of producing the report it says:

The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) .  I can't figure out for the life of me what got changed and we really need this up.

Thanks in advance,

N
0
Comment
Question by:stretch73
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 2000 total points
ID: 20376743
0
 

Author Comment

by:stretch73
ID: 20377189
I tried everything on that page and still no luck.  I looked at the logs and it says the web service account hasn't been specified correctly.  The thing is, if I put the account name in the actual file, the service won't start.  Added to which I think you're supposed to be able to add the account name in the configuration management tool.  Totally stuck here.
0
 

Author Comment

by:stretch73
ID: 20377376
Got it, turns out these two accounts needed write access to the ReportServer folder

SQLServer2005ReportingServicesWebServiceUser$
SQLServer2005ReportServerUser$

Thanks SSD, that got me where I needed to be.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question