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…
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.
- 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.