Search This Blog

The Permisssion Granted to 'Domain\User' are insufficient for Performing this Operation SSRS Reporting Issue in SharePoint

The Permisssion Granted to User 'Domain\User' are insufficient for Performing this Operation SSRS Reporting Issue in SharePoint.


After Migrating from  SharePoint 2010 to SharePoint 2013 while opening any of SSRS Reports or Dataconnection file we were getting the below Error.










Below are the steps to Resolve the Issue

1.Giving DB owner permission to User for  Database used by SP and Reporing.

Security-Right click- loginName-UserMapping-checkbox-DB_owner (Screenshot1)

Screenshot1.

2-Changing the Reporting Service Account to your USer(Before that it was Running with windows Account).

Services-SQL Server Reporting Services-Right click-Properties-Log on (Screenshot2).
Running SQL Server Reporting Services with that User x.

3-Final Step is giving permission to  user x for Reporting Service in SP.

SP Central Admin-Application Management-Manage Service Application-SQL 2012 Reporting Service Application –Click-Permissions(Top of Page)-Adding User x-Checkbox-Full Control (screenshot3).


Following Above steps will Resolve the Permission Issue with the Users.

Note:Above Steps are Perfomed in SQL 2012 and SharePoint 2013 Central Admin.





No comments:

Post a Comment