Paul Liebrand's Weblog

Welcome to my blog mainly about SharePoint

Skip to: Content | Sidebar | Footer

Google Search

SSRS and Permissions granted to user are insufficient for performing this operation.

25 September, 2013 (09:48) | SharePoint | By: Liebrand

If you are running SharePoint 2013 and SSRS 2012 in SharePoint integration mode and you attempt to do anything related to SSRS such as Editing Data Source, you might receive the following error:

The permissions granted to user ‘domain\username’ are insufficient for performing this operation. —> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘domain\username’ are insufficient for performing this operation.

SSRS

This could be caused if your SSRS account has not been granted access to the web application. To resolve this issue, simple run the following PowerShell commands:

$webApp = Get-SPWebApplication –Identity http://yoursharepointapp
$webApp.GrantAccessToProcessIdentity(“domain\SSRSAccount”)

At this point, you should be good to go.


Post to Twitter Post to Delicious Post to Digg Post to Facebook Post to Reddit

  • johnmcclain77

    THANK YOU!! I have been banging my head for two days. This did the trick!

  • Glad I could help!

  • Vincent Ha

    Thank you, confirmed this is the solution.

  • Guillermo H

    you can use whis scritp to read your service account instead

    # Grant application pool account access to the port 80 web application’s content database.
    $webApp = Get-SPWebApplication $WebAppUrl
    $appPoolAccountName = $appPool.ProcessAccount.LookupName()
    $webApp.GrantAccessToProcessIdentity($appPoolAccountName)

  • This worked for me…! Thanks for saving my day.

  • Antonio

    Thanks! This fixed my problem!