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

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

Cant pass 0 in stored procedure parameter

Hi
I have an if clause in my code to add the final parameter value to send to the database.

If Page.User.IsInRole("MICMS") Then
cmdCheckUser.Parameters.Add("@.C_ID", 0)
Else
cmdCheckUser.Parameters.Add("@.C_ID", Session("C_ID"))
End If

If the user is in the role, the error is triggered saying that @.C_IDis expected by the stored procedure. If i then change the value from 0to 10, the stored procedure works fine.
Is there any reason that the stored procedure is failing when the value 0 is used and not when any other value is used?
Thanking you in advance.Because the parameters.add is overridden based on what is passed (look at them when you hit the left parens). Since you are passing a numerical value of a low number, it thinks that it is the sqldbtype. You will need to cast the value to a string cStr(YOURVALUEHERE).
Nick

can't log in with MS SQL Web Data Administrator

Installed MSDE with the SAPWD parameter. Installed the MS SQL Web Data
Administrator, started Cassini on port 81 since it didn't like port 80.
Can't get the login to work at http://localhost:81/webadmin/default.aspx. I
keep getting "Invalid username and/or password, you are using a windows
login that is not your own, or server does not exist.". For the machine name
I tried (local), localhost, and my machine's network name, for the login I
tried the sa SQL login and my Windows login. Nothing's working. I'm
obviously doing something wrong, anyone want to clue me in?
BTW my machine is XP Pro.
TIA,
Paul
I have the same problem. Anyone any ideas?