September 12, 2012 at 9:28 am
I have a Visual Studio web application that includes SSRS report. When I try to build, I see in the Output window that all the reports are getting deployed to the server, but one particular report gives me the error "The permissions granted to user 'DOMAIN\MyID' are insufficient for performing this operation." while its deploying. This forces the build to fail. Can anyone tell me what to look for in this case? What could be causing it?
September 14, 2012 at 1:00 am
No more info in the build output?
September 14, 2012 at 6:37 pm
Actually I figured out a solution. It wasn't easy but it turned out that the report I was trying to deploy was already existing on the server, but it was under someone else's account. The owner was some other user. I didn't see it for some reason. When I looked into the Catalog table in the ReportServer database, I had to UPDATE an ID field in this table to show me as the owner instead. There's a GUID field that represents the user id. When I did that, I was able to see the report and then I was able to deploy and replace it during development.
Please note that this was attempted on a development server where I had full permissions, which is why I couldn't understand why I didn't see the report, nor was able to replace it.
Hope this might help someone.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply