I'm having trouble with SQL Server 2008 (Express with Advanced Services) Reporting Services permissions. I'm running this on Vista Ultimate at home - standalone machine with no servers, no domain or active directory.
When I go to the ReportServices site, I get this:
The permissions granted to user 'localmachine\Scott' are insufficient for performing this operation. (rsAccessDenied)
I don't remember having a problem at the office with SQL Standard on Windows 2008.
Try running IE as admin and then going to the page. Then under settings add your user and give it permissions. You should be able to run IE not as admin after that. This worked for me using SSRS 2005 under vista.
If not that, then check which user account the service is running as.
See the MSDN page about How to Configure Reporting Services on Vista and Server 2008
Phillip Wells said: "I have the same problem. I've tried running IE as admin then going to the page, but I'm still getting the access denied error. Any suggestions?"
I also have this problem. I run IE as Administrator but still get the access denied error. It seems that IE still not run as Administrator. Then I tried to use other browser (I tried Google Chrome) as Administrator. Then boom! The Home Page of SQL Server Reporting Services Manager is shown up with the tab Properties. I click it. I add my account to become the Content Manager. Then I open IE as usual (not as Administrator), and then I can browser and manage the SSRS Manager site.
Hope this helps, -Fu-