SharePoint Integration Mode SSRS : Permissions granted to user are insufficient for performing this operation

By -
Hi There,

Its December 30 2015 12:30 PM and my team has to show demo to client at 02:00 PM. Received a call from my team that editing a data source from a SharePoint list is throwing an error. Wow, that's critical and i would love to fix this. I quickly googled and tried every solution i found on first page but didn't work.

"Google says, the best place to hide a dead body is on google's second search page."

So i navigated to move ahead with search on second page and found this awesome post that fixed my issue. I took the below steps which didn't helped me.

1. My permissions was OK on reporting DB,s
2. The account i am using for editing the data source was the system account
3. Restarted the SQL Server Reporting Services in SharePoint CA

BTW, i am running SharePoint 2013 in a three tier farm architecture with SSRS SharePoint Integration Mode. Below are the error details...

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.


This could be caused if your SSRS account has not been granted access to the web application. I ran below commands in PowerShell which worked perfectly fine for me.


$webApp = Get-SPWebApplication –Identity http://WebAppURL.com
$webApp.GrantAccessToProcessIdentity("Domain\ReportsServiceAccount")


Enjoy...!

Happy SharePointnig...! :)

Comments

  1. ~RKJune 23, 2020 at 3:04 PM

    Hi,
    Can you please help me below.. case is same but Site is migrated and destination domain is not the same:
    SharePoint Integration Mode SSRS : Permissions granted to user are insufficient for performing this operation.
    CASE: Site Collection migrated to different Domain (Source: OldDomain, Destination: NewDomain)
    Error: The permissions granted to user ‘domain\username’ are insufficient for performing this operation. —> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException..

    ReplyDelete
    Replies
    1. Xeeshan TahirOctober 16, 2020 at 3:03 AM

      I believe, this will result you to create a new data source to correct the domain. I am very sure it will not allow you to update and may be you have to end up by creating a new one. Please do post the solution which worked for you so it may help others.

      Delete

Post a Comment

Popular Posts

GREYCstoration Oil Paint plugin for Photoshop

By -
Image
Oil Paint Filter is missing in Photoshop? Try GREYCstoration plugin. An alternate for Oil Paint filter. I found my Adobe Photoshop CS5 is missing Oil Paint filter plugin due to GPU unavailable on my machine. I found an alternate tool to get oil painting effect on photos. Below are the steps to use this tool. 1.  Download  tool and extract http://www.mediafire.com/download/3j15dj3opmip4ez/GreycShop.zip 2. Copy the extracted files on below path(s)     For 64Bit: C:\Program Files\Adobe\Adobe Photoshop CS5 (64 Bit)\Plug-ins     For 32Bit: C:\Program Files (x86)\Adobe\Adobe Photoshop CS5\Plug-ins 3. Run Adobe Photoshop 4. Select Noise >> GREYCstoration  For example: Enjoy :)
Read more

Service Bus Gateway service stuck at Starting

By -
Image
Lesson Learned: Never leave your servers to automatically download and install the updates. We had a SharePoint farm where Workflow manager is configured on one of its server and rest of them are just using WFM client to connect with the server. Everything was running smooth until some updates got installed on the servers over night and the next morning Workflows stuck and start giving errors. As initial check, I verified SharePoint services and WFM services, noticed that the Service Bus Gateway service is struck at Starting state. This was very generic thing but at least a point to start thinking... Troubleshooting: 1. Tried manual restart, but no luck. 2. Tried Leaving and Joining the WFM Farm again. But the timeout error. Error message received during rejoining:  “Starting Service bus gateway on machine <servername> failed: timeout has expired and the operation has not been completed” 3. Tried ULS check and noticed below error. "  Service cannot be started. Microsoft.Ser
Read more

PowerApps SubmitForm not clearing People Picker value

By -
Image
Although its a great experience working with Microsoft products but sometimes they surprises you with bugs that being a developer you would not expect. You may come across the problem that PowerApps SubmitForm is not updating data in SharePoint list, specially the People Picker type field (could be the same case with datetime type as well. Same thing I have experienced that while working on a PowerApps form which is connected with simple SharePoint list, I was unable to update the value of People Picker control which was having no special settings in SharePoint, just simple out of the box list with Title and a People Picker column. Spent hours on it but no gain. Finally the Google, a friend who can help you to find the right thing if you search for it. I came across this and this post and found similarity. Made the same changes and boom...! It worked..! You just need to turn ON the Fomula level error management under the Advance Settings. Below is the settings which I set to Yes. Have
Read more

Apple iPhone sending SMS automatically 00447786205094

By -
Image
Hi There, I have just noticed that my credit is being deducted from my mobile account. I am in Pakistan and using Warid Tel network. I see my mobile credit details after few hours on my screen. This facility is provided only by Warid Telecom that they provide your credit details each time you make a call or send SMS. I checked my Message,Calls logs emails logs etc but no point where i can check that why me credit is being deducted. Absolutely nothing found. :-/  I called Warid Tel support center and the guy told me that there are 4 SMS that have been sent internationally from my iPhone 5. Whattt???? :O I have't sent even a single one. He was bound not to tell me the number however i found that number from Warid Tel online customer portal. That magical number was  00447786205094. Warid Web Self Service Portal I googled and found that its UK number and an iPhone application Facetime/iMessage used to send text to this number for their activation without
Read more

Download file failed signature verification and may have been tampered with - Workflow Manger 1.0 Refresh (CU2)

By -
Image
Since there is no major updates in Workflow Manager installation process for last couple of years, the offline installation became really difficult. Microsoft recommends to install it through WPI  tool, however sometimes the online installation also becomes a nightmare. This is what happened recently. Problem Description: For one of our client, we had to prepare environment with following. SharePoint Server Enterprise 2019 Window Server 2019 Standard Workflow Manager 2013 As usual I followed the same installation guide which ran fine few weeks ago with another different environment but here we faced the below error while installing Workflow Manager Refresh 1.0 (CU2). "The product did not install successfully. Download file failed signature verification and may have been tampered with" Tried to run the setup multiple times but nothing helped. Checked all the available discussion threads on Microsoft's and other forums but nothing helped much. However I must thanks PeterFle
Read more