Reporting Services 2008 R2 running on local machine

If like me you prefer to use Firefox rather than Internet explorer then you might run in to problems when setting up SQL Server Reporting Services on your local machine for development.

By default SSRS allows only local administrators to access the report manager. To use non-administrators you have to log in to the server using an administrator account and then create a new role assignment for the non-administrator roles, however, what if you cannot get in to the report server at all – even using a local administrator?

You will probably see this error in the reporting services log file…

Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException

and this might show on the browser page

The permissions granted to user ‘DOMAIN\user’ are insufficient for performing this operation. (rsAccessDenied)

Two problems exist here. One is the UAC (user access control) and the other is the choice of browser.

You have to use IE (and possibly even add the localhost as a trusted site)

  • Open Internet Explorer as Administrator(Right click the IE exe and choose “Run as Administrator”
  • Go to the “SQL Server Reporting Services” Home page (http://localhost:port/Reports) which will redirect to http://localhost:port/Reports/Pages/Folder.aspx
  • Click on the “Folder Settings” button.
  • Click on the “New Role Assignment” button.
  • Add the Group or user name: DOMAIN\USER_NAME

Q. So why can’t you do this using Firefox?

A. I have no idea (world domination?), however, I do know how to get around it.

Trying it in Firefox gets you the following message even if you run as Administrator

User ” does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

But if you run Internet Explorer as administrator and then add the current user with a role assignment (content manager is best) then you can go back to Firefox and everything works fine.

Alternatively…

  • Go to the start menu -> RUN and type UAC (enter).
  • Turn UAC off
  • Restart computer
  • Run Firefox as admin and then make change
  • Put UAC back on
  • Restart computer

This is more of a pain but if you don’t have IE on your machine its the only option.

Note however that MS don’t support other browsers very well in SSRS so there are other issues when using Firefox, particularly around security. Chrome often doesn’t work at all.

Advertisements

About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)
This entry was posted in Developer stuff, SQL Stuff and tagged , , , , , , , . Bookmark the permalink.

One Response to Reporting Services 2008 R2 running on local machine

  1. Dan Buckley says:

    6 hours I’ve been messing with this! Thanks

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