The permissions granted to user are insufficient for performing this operation (rsAccessDenied)

0
votes

I created a report project in Visual Studio 2015 and deployed it and got the URL without errors and it worked in INTERNET EXPLORER. I got the reports on the first day but the next day I got an error

The permissions granted to user are insufficient for performing this operation (rsAccessDenied)

Then I changed the internet explorer local intranet settings (user authentication --> logon) but didn't get the reports.

Kindly help me solve this issue.

1
reporting-services
Check if user running VS is added to SSRS users, and that permissions granted to him. You probably running IE under different users, or SSRS settings changed. – grafgenerator
@grafgenerator can you please post me the steps in granting user permissions. – shyam
Check this two tutorials - technet.microsoft.com/en-us/library/aa337385(v=sql.105).aspx and technet.microsoft.com/en-us/library/aa337471(v=sql.105).aspx Give your user System User and System Admin roles, and grant everything available in folder permissions. – grafgenerator
@grafgenerator when i run my report manager URL in the browser i get an error called (User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.) how to overcome this ? – shyam
Try to run browser as admin, if you didn't already do that. Also, try to temporary disable UAC. – grafgenerator

1 Answers

1
votes

You need to grant access rights to user you're accessing the reports server. There are MSDN tutorials for that: 1, 2, but short steps are:

  • Open reports portal.
  • Go to Settings page -> Security tab, and add your domain\user to the list of users as administrator.
  • Go to reports page again.
  • Click Manage folder, on opened page open Security tab.
  • Add your domain\user to the list of users with all available premissions.

If you can't open reports portal in Chrome, try to access it in IE, and if it's not working, try to run IE as administrator.