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