Saturday, February 25, 2012

Permission problem

I get the following error at times:

The permissions granted to user 'PMS\rforkner' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

The user is me and I am the administrator and owner of the SQL Server 2005 database. SQL Server is running on Windows 2003 Server Enterprise SP1. How is it I don’t have permission to change a change a permission. For the past several days I have added users and set the permissions (in Report Server). What I had done was uncheck Browser for my account and that worked. When I tried to check Browser and OK is when I got the error.

Any ideas, suggestions, or comments are certainly welcome

Roy

Hi RoyAF,
i guess it is possible that when you check Browser (I really don't know the exact place where you do that) you are using another user. It is just as logging with your NT user accnt and surfing by the built-in accnt for IIS; that built-in accnt is NOT admin on the Report Server and this is why you get the error.
I have posted a question on about the same problem - it seems that you must have admin rights on the RS to do anything (including viewing reports).
I am waiting for someone to confirm that this problem goes away if you uninstall SP1 for W2K3.
If you get to talk to anybody and can shed more light, please post back,
thanks,
kowalsky|||kowalsky,
I have full privilages to the server, sql server and of course RS. I have sa rights. The strange thing is, that it worked until I unchecked browser on I had rights then but, a few minutes later when I tried to check browser on built in I no longer had the rights.
It is really frustrating and I have no idea where to get answers other than here. I have posted numerous questions about problems and I have had only 2 answers. Maybe my questions are so easy no one wants to bother answering.
I really like the product and I know it is beta but it seems to work for some; I just wish I could make it work for me.
Roy
|||This is crazy; today all the permission problems have disappeared and all is working as it should. The face that yesterday was a problem and today isn't makes me wonder what is happening.|||

RS has to call out to the Domain Controller to ensure you are who you say you are. If the network connectivity between the DC and RS is unstable, this kind of issue can occur.

Removing the Browser role should not affect your ability to set permissions because the default definition of Browser does not grant you this right.

Hope that helps,

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment