Tuesday, September 17, 2013

SSRS - You do not have sufficient priveleges to access this report

Other Errors:
There are a myriad of error messages pertaining to security access that you may encounter when attempting to access the SSRS portal using Internet Explorer.

Solution:

Make sure you login as the Domain Admin first so that you can give admin access to any other users

  1. Add the ssrs website to your trusted intranet zone
    1. Find your SSRS site address by using the Reporting Services configuration Manager or going to GP>Tools>Setup>System>Reporting Tools Setup
    2. Browse to your SSRS site, get the error
    3. Internet Options>Security>Local Intranet>Sites>Add the current site
  2. Right click Internet explorer and choose Run as Administrator
    1. If it brings up another menu with a small internet explorer icon, just right click on that icon then run as administrator
  3. Open your SSRS site
    1. Click on Site settings in the top right hand corner
    2. Security>New Role Assignment
    3. Type in windows username that should be an administrator in SSRS, tick System Administrator, click ok
    4. Repeat this for as many administrators as you need
  4. Now you should be able to login with a normal windows account (you will have to repeat steps 1 and 2 to set the IE settings for this windows account)
    1. You should be able to login and access the reports normally.
    2. If this still does not work, right click and run IE as administrator.

No comments:

Post a Comment