Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : The permissions granted to user 'SANROSYS\SANSVR1$' are insufficie


Duraiprakasam
6/1/2006 4:37:01 AM
The permissions granted to user Domainname\MachineName' are insufficient for
performing this operation. (rsAccessDenied). After deploying the rdl file
rwiethorn
6/19/2006 12:56:01 PM
Duraiprakasam,
I got the same error, and it just dawned on me while I was
searching this newsgroup for a solution. {This may be wrong, so someone
please chime in and correct/add to what I say}

If you were designing reports on your local machine using VS Report Builder,
and viewing on the Report Manager, you were the admin, in the admin group.

If you happened to add users to your machine, and create a local group, and
let them run reports via the report manager, as in my case, you gave them
direct access.

Now when you make a web app (aspx) page using the ReportViewer control, the
authenticated user is no longer the you, or someone in the local group, its
now the IUSR_Machine who is making the request. I think you need to grant
that user access in the ReportManger tool.

So, thats what I'm going to go do.
-rwiethorn

[quoted text, click to view]
rwiethorn
6/20/2006 5:08:01 AM
Its not IUSR_Machine, it was the Macine\ASPNET account. So, give it a try and
see what you get.

-rwiethorn

[quoted text, click to view]
AddThis Social Bookmark Button