0

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.

shyam
  • 23
  • 1
  • 1
  • 5
  • 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 Nov 03 '16 at 08:19
  • @grafgenerator can you please post me the steps in granting user permissions. – shyam Nov 07 '16 at 07:03
  • Check this two tutorials - https://technet.microsoft.com/en-us/library/aa337385(v=sql.105).aspx and https://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 Nov 08 '16 at 06:07
  • @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 Nov 08 '16 at 06:27
  • Try to run browser as admin, if you didn't already do that. Also, try to temporary disable UAC. – grafgenerator Nov 08 '16 at 06:45
  • @grafgenerator Thank U very much....I got my reports in internet explorer. But I am not able to get it in google chrome. – shyam Nov 08 '16 at 07:33
  • So the issue is with access rights. Open reports portal in IE and go to Settings. On the settings page, go to Security tab, and add your domain\user as administrator. Then go to reports page again, click Manage Folder and on Security tab add your domain\user to list with all available permissions granted. – grafgenerator Nov 08 '16 at 07:55
  • @grafgenerator Got my reports in chrome finally. Thank u for helping me to sort out issues. :) – shyam Nov 08 '16 at 09:10
  • I will post an answer, so you will be able to mark it as accepted:) – grafgenerator Nov 08 '16 at 09:35

1 Answers1

1

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.

grafgenerator
  • 679
  • 7
  • 13