SQL Server Reporting Services 2008 on Windows 7 / Windows Server 2008 R2
This week I installed SQL Server 2008 R2 November CTP on my Windows 7 workstation. Because I want to delve somewhat deeper in building reports for SQL Server, I also installed the SQL Server Reporting Services. The installation went incredibly smooth and the configuration through Reporting Services Configuration Manager didn't throw any errors.
When opening a browser and browsing to http://localhost/reportserver I received - (it has to happen sometime) - an error:
The permissions granted to user ... are insufficient for performing this operation. (rsAccessDenied)
I spent a lot of time searching and checking the Reporting Services configuration files for hints to what could be going wrong. After all, my account was a local administrator AND the service account under which Reporting Services was running.
Finally I found the solution! It was way too simple actually... Just open your Start menu and locate the Internet Explorer icon. Right click on the icon and choose "Run as administrator"... Problem solved! :)