Saturday, February 25, 2012

Can't pass parameter - rsAccessDenied

I am having a problem passing a parameter. When it gets to the last line of code where I set the parameters, I get this error. Can anyone help?

  • The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

    Here is my code:


    ReportParameters(0) = New ReportParameter("ProjectKey", 262)
    rv.ShowParameterPrompts = False
    rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
    rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
    rv.ServerReport.SetParameters(ReportParameters)

    I have the same problem. It seems that setting user access rights in RS is a big nightmare. One wrong step, and the whole thing collapses, you need to reinstall YUKON from scratch.

    |||

    You'll need to grant network service permission to view the report.

    Do that in report manager or management studio. If you have the default roles, you should just assign the Browser role.

    If the report server is on a remote computer, you'll need to grant to the machine account: <domain>\<machinename>$.

    Does that answer your question?

    -Lukasz

    |||

    John, what specifically are you referring to? Do you know that if you login as a member of the local administrators group on the computer that hosts the report server, you can always set permissions?

    -Lukasz

  • No comments:

    Post a Comment