I have installed SQL Server 2008 Reporting Services on my development laptop running windows 7. When I browse to the report manager, only the header is shown. The content pane is blank, and there is no 'Site Settings' option, New Folder options, etc. I found plenty of similar stories about SQL 2005, and then the fix was to manage permissions in the virtual directory in IIS. However, in 2008, there is no virtual directory – RS manages this outside of IIS.
Per other serverfault articles, I've tried the following:
- adding my account to the reporting services group
- changing the service to run as local system
- made sure localhost was trusted site in IE
- ran IE as admin
- installed SQL Server 2008 SP1
There are no errors in the event viewer. Perhaps related, if I browse to the webservice, I also get the error:
The permissions granted to user 'Computer\User' are insufficient for performing this operation. (rsAccessDenied)
Best Answer
I just set 'Trusted Sites' to 'Low' in IE and it now works. This page was helpful: