I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied) Here is my code: Dim u As New UriTypeConverterDim ReportParameters(0) As ReportParameter ReportParameters(0) = New ReportParameter("ProjectKey", 262) rv.ShowParameterPrompts = Falserv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error. In addition, I get this DCOM error in the system log: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {BA126AD1-2166-11D1-B1D0-00805FC1270E} to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool. I'm not exactly sure what and how to do in Component Services admin tool.

This thread may help you with the DCOM error: http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

Netman has both local activation AND execution

Do you see Network Services part of RSExec role in your report server catalog db and temp db?

Yes

Yes, Network Servicesis RSExec role inreport server catalog db and temp db.

It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininumpermission set.Can you try adding the account as a content manager to the home folder?

If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.

I have added the NetworkService as administrator and still no go.

That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help

Sorry--Don't follow what the fix was. What did it?

Went into Report Manager and gave NT Authority\NetworkServicethe necessary role assignments.

Thanks--got past that one, now I get to deal with the database access permissions lol...

Run the Reporting Services configuration utility from the configuration tools program group under theSQL Server 2005 program group. Thereis an icon (green check if OK - red X if not) for database setup on the left side. Alsomake sure the NetworkService account has the RSExec role for database role membership in the ReportServer database and the ReportServerTempDB

Thank you!

If this helped, then you're quite welcome.

One more--(been banging on it for a while but I just must be stoopud or something)--I tried specifying aparameterbut get: Error1The type or namespace name 'ParameterValue' could not be found (are you missing a using directive or an assembly reference?) I have using Microsoft.Reporting.WebForms; in my directives, so I don't understand... This is the simplest case scenario - VS2005 etc, create a web project, drag and drop the ReportViewer control on the default.aspx web page, set the ReportServerUrl and ReportPath values in the smart tag, solved the above forum problems, when I F5 the report executes and shows data in the report viewer if I don't have my parameter code(the one parameter defined in the report has a default value). All I need to do is get past this thing, here is my code for the parameter setting (C#): ParameterValue[] parameters = new ParameterValue[1]; parameters[0] = new ParameterValue(); parameters[0].Name = "Customer"; parameters[0].Value = "3"; ReportViewer1.ServerReport.SetParameters(parameters); There must be something simple I am missing...

In the words of Emily Latella--Never mind. I got it. The eyes start going when one is a geezer. "ParameterValue" is wrong, that is code I copied from another program where I was using the reporting services webservice apis instead of the ReportViewer. Changed to "ReportParameter" and everything works. Thanks!!!

When you say "gave NT Authority\Network Servicethe necessary role assignments." Do you mean you gave that user Content Manager rights on the report server. I am having a problem getting past the rsAccessDenied message and I don't know what more rights I can give. The message comes up when I try to run a report from Report Builder. I can save the report and run it fine but if I try to run it from Report Builder I get my own domain\userid showing as having insufficient permissions. I have local administrator rights on the reporting server and SA rights on the Database I running against. Can you shed any light as to what my problem is? Thanks!!!

If it is your own domain\userid showing as having insufficient permissions - I haven't worked with Report Builder much, but I believe it runsunder the logged on user's account with respect to security. That means you would have to add your own specific domain\userid to the list of roles in the security settings for that report in the Report Manager. I would begin by giving it all the roles (verify it works), then begin removing roles one at a time to see what the minimal one-or-more roles are necessary.

Also check the server's Event Viewer out (try all 3 logs) to see if you can see more detailed error info. Other helpful things to look at: Being in SQL Server Profiler to look at details about executing queries; the IIS logs located at C:\WINDOWS\system32\Logfiles\W3SVC1; the SSRS logs located at C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles (note there are 3 different types of logs kept there).

go to the address http://servername/instancename/ReportsClick "Properties" and check that you have a role assignment set to "browse" or "Content Manager" for the appropriate windows group or user, I think by default afaik is "built-in\administrators"

I also found out that if you have anonymous enabled on your ReportManager it will result to the same issue.

Hi - I am still a little lost so let's see if one of you folks have hit the same brick wall the same way I did. We have our Report server on our web server (server A) and report server databases on the database server (server B), so I am not sure if the issues gets more complicated at this level? Plus we are trying to not use WebForms to authticate anyone. This will be a public website without any login information. So what settings and permissions do I need to fix to get rid of this rsAccessDenied error? Thanks,

I'd like to come in on this one because it's driving me mad and I don't see the answer in any of the previous posts.I have two machines - both our standard XP buildOn the right hand one, logged in as me (domain admins and SSRS admin/full control) I can load Report Builder 1 and see the report model. I open it and drop a field in, then it runs.On the left hand machine, a user I have created to mimic our standard users (username "atest"), not IT or admins. I load Report Builder 1, same report server, load the same report model and drop the same field in but when I run it I get the error - "Report Execution error" and the details are "The premissions granted to user {domain}\ATEST are insufficient for performaing this operation (rsAccessDenied)"I have placed this user into each of the folder-security on the report server as "Browser", "Report Builder" and "Publisher" so the user should be able to run the report.If I place that user in the Windows AD group that administers the server, then it works. Take the user out again and it doesn't.Can anyone help?Thanks

This thread may help you with the DCOM error: http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1 Your effort is appreciated! It's very useful.