Solved

SQL Reporting Services Error - rsAccessDeniedToSecureData

Posted on 2007-11-29
3
5,223 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
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

813 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now