Administrator has no access to the Report Manager (SQL2008 R2 and Windows7/Vista)
Today I wanted to start playing around with the new Report Manager of SQL 2008 R2.
After installing and configuring R2, I opened Internet Explorer and entered the URL of the Report Manager. In my case: http://localhost/reports_r2
I got a very empty Report Manager 
:
Okay, something is wrong. I tried to connect to http://localhost/reportserver_r2 :
No access? But I am admin of this PC… Wait a minute. By default, programs are never executed as an administrator in Windows 7 or Vista. That explains it!
Here is how you can solve this:
- Open Internet Explorer as an administrator: click right and select “Run as Administrator”.
- Click “Yes” to allow.
Now, if you don’t want to do this every time you want to use the report manager, follow these steps:
- Add “http://localhost” to the trusted sites.
- On the home page of the report manager click “Folder Settings”, “Security” and make your account “Content Manager”.
- Click “Site Settings”, “Security” and make your account “System Administrator”.
- Problem solved!
For more info: search for “How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008” in BooksOnline.
Hi,
I ran as “Administrator” but still not getting “Properties” on Report Manager page. Any idea?
Thanks
Did you try to add the report manager site to the “Trusted Sites”?
If it still doesn’t work, check the security settings of the Trusted Sites and change the User Authentication to “Automatic logon with current username and password.”
Hi
I am testing the custom security extension and am just using the Microsoft sample and getting the empty page. I have tested all of the steps which you have mentioned with no luck. FYI I have changed the directory security to anonymous but it’s running under a domain user which is a domain administrator. Any other reason do you know which can cause this issue?
Thanks
Mohsen