Home > Database, SSRS > rsAccessedDenied – SQL Server 2008 R2 – Reporting Services

rsAccessedDenied – SQL Server 2008 R2 – Reporting Services

Recently I installed SQL Server 2008 R2 in my Laptop and I was in a process of configuring SSRS using “Reporting Services Configuration Manager”. Therefore I went to the following URLs:

Report Server: http://localhost/ReportServer
Report Manager: http://localhost/Reports/Pages/Folder.aspx

The page took more time to load, however gave me the following error even thou I was sure that I gave windows authentication for security during installation.

Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings
The permissions granted to user ‘mydomain\myAccount’ are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

After a long research, I finally discovered that you have to open Internet Explorer in administrator mode (Right-Click and Open as Administrator) and try navigating to the above URLs. This is because initially the SSRS will have the following group “BUILTIN\Administrators” as “System Administrator” and you have to explicitly open as administrator when using Internet Explorer.

You will discover that this time you are able to load the pages and the first thing for me to do was to click on the “Site Settings” and under the Security option added my username as “System Administrator” under “New Role Assignment”.

After this done, you will notice that you can open up the Report Server / Manager URL’s under normal mode (without opening it as Administrator)

More Info from MSDN: http://msdn.microsoft.com/en-us/library/aa337279.aspx

Hope this is of help to somebody who is caught up with this issue.

Advertisements
  1. Anonymous
    December 21, 2011 at 9:32 PM

    thanks, worked like a charm 🙂

  1. February 14, 2013 at 5:11 PM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: