SSRS 2012 - Custom Authentication - The permissions granted to user " are insufficient for performing this operation

Question

Whenever I want to deploy a report in Visual Studio I receive the error message

The permissons grated to user " are insufficient for performing this operation".

I am using custom authentication (with a form) on the Report Server / Manager and the Login via the Webpage works fine. Further, I also added an administrator role to the Report Manager. In Visual Studio I then changed the credentials in the Shared Data Source from Windows Authentication to "Use this user name and password" and specified the administrator name. However, I still receive the same error message and the user " part of the error seems to indicate that Visual Studio tries to connect with an empty user name.

Can you please help me to fix this problem?

Answer 1

You need to add an override for the authorization portion. It may be that you are authenticating the user, however, SSRS needs to know if the authenticated user can update report definitions by given authorization. If you are using custom security then you should look adding authorization for the user.

Answer 2

I had the same problem, This issue was in my web.config (located at C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer) I had the below configuration for Report Service asmx file. When I commented the below lines every thing was normal. I was able to see the login dialog prompting for the user name and password.

<location path="ReportService2010.asmx">
<system.web>
  <authorization>
    <allow users="*"/>
  </authorization>
</system.web>

Hope this help someone else. More details can be found on this blog http://blogs.msdn.com/b/bimusings/archive/2005/11/29/497848.aspx