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: 350

Filed under:

 

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

 

  1. Continue to run IE as administrator, you must still add the report server site to trusted sites
  2. Add the site to trusted sites and manually add the user to the system administrator and content manager role
    1. 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.
    2. Click Allow to continue.
    3. In the URL address, enter the Report Manager URL.
    4. Click Tools.
    5. Click Internet Options.
    6. Click Security.
    7. Click Trusted Sites.
    8. Click Sites.
    1. Add http://<your-server-name>.
    1. Clear the check box Require server certification (https:) for all sites in this zone if you are not using HTTPS for the default site.
    1. Click Add.
    1. Click OK.
    2. In Report Manager, on the Home page, click Folder Settings.
    3. In the Folder Settings page, click Security.
    4. Click New Role Assignment.
    5. Type your Windows user account in this format: <domain>\<user>.
    6. Select Content Manager.
    7. Click OK.
    8. Click Site Settings in the upper corner of the Home page.
    9. Click security.
    10. Click New Role Assignment.
    11. Type your Windows user account in this format: <domain>\<user>.
    12. Select System Administrator.
    13. Click OK.
    1. Close Report Manager.
    1. 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