Accessing SSRS Report Manager on Windows 7 and Windows 2008 Server
Posted
by Testas
on SQL Blogcasts
See other posts from SQL Blogcasts
or by Testas
Published on Thu, 03 Jun 2010 10:52:00 GMT
Indexed on
2010/06/03
11:35 UTC
Read the original article
Hit count: 358
Here is a problem I was emailed last night
Problem
SSRS 2008 on Windows 7 or Windows 2008 Server is configured with a user account that is a member of the administrator's group that cannot access report Manager without running IE as Administrator and adding the SSRS server into trusted sites. (The Builtin administrators account is by default made a member of the System Administrator and Content Manager SSRS roles).
As a result the OS limits the use of using elevated permissions by removing the administrator permissions when accessing applications such as SSRS
Resolution - Two options
- Continue to run IE as administrator, you must still add the report server site to trusted sites
- Add the site to trusted sites and manually add the user to the system administrator and content manager role
- Open a browser window with Run as administrator permissions. From the Start menu, click All Programs, right-click Internet Explorer, and select Run as administrator.
- Click Allow to continue.
- In the URL address, enter the Report Manager URL.
- Click Tools.
- Click Internet Options.
- Click Security.
- Click Trusted Sites.
- Click Sites.
- Clear the check box Require server certification (https:) for all sites in this zone if you are not using HTTPS for the default site.
- Click Add.
- Click OK.
- In Report Manager, on the Home page, click Folder Settings.
- In the Folder Settings page, click Security.
- Click New Role Assignment.
- Type your Windows user account in this format: <domain>\<user>.
- Select Content Manager.
- Click OK.
- Click Site Settings in the upper corner of the Home page.
- Click security.
- Click New Role Assignment.
- Type your Windows user account in this format: <domain>\<user>.
- Select System Administrator.
- Click OK.
- Close Report Manager.
- Re-open Report Manager in Internet Explorer, without using Run as administrator.
Problems will also exist when deploying SSRS reports from Business Intelligence Development Studio (BIDS) on Windows 7 or Windows 2008, therefore you should run Business Intelligence Development Studio as Administor
information on this issue can be found at <http://msdn.microsoft.com/en-us/library/bb630430.aspx>
© SQL Blogcasts or respective owner