locked
SSRS Install/Config Issue RRS feed

  • Question

  • User301788237 posted

    I installed SSRS 2008 on a Windows 2003 Server using the default install configuration.  I created a test report and set to security to allow everyone access to view it.  When testing from the server, logged on with my admin account I can access the reports using http://servername/reports.  But when I go to a user's machine, using that user's login, I cannot get to the reports using that configuration.  But if I go to SSRS configuration manage and change it to use the IP address then the user can get to the reports.  This is not the optimal solution, so how to fix?

    Second issue is the print button causes IE 10 to crash.  I have tried all of the IE settings suggested for this problem, including adding the SSRS IP path to the trusted sites.  How to solve this?  I am thinking these 2 issues are related.  Thanks

    Sunday, August 25, 2013 8:43 AM

All replies

  • User1143442848 posted

    Hi,

    According to your description, there is a problem with the SSRS accessibility. 

    SQL Server Reporting Services uses role-based security to grant user access to a report server. On a new report server installation, only users who are members of the local Administrators group have permissions to report server content and operations. To make the report server available to other users, you must create role assignments that map user or group accounts to a predefined role that specifies a collection of tasks. 

    More information, please try to refer to the following links:

    # Grant User Access to a Report Server (Report Manager)

    http://technet.microsoft.com/en-us/library/ms156034.aspx

    # Tutorial: Setting Permissions in Reporting Services

    http://technet.microsoft.com/en-us/library/aa337491(v=sql.105).aspx

     

    If you need more assistance, please feel free to let me know.

    Best Regards,

    Lisa Zhang

    Monday, August 26, 2013 9:55 AM
  • User301788237 posted

    Thanks for your reply Lisa.  I set up security to everyone, following the procedure the link refer to.  Access is granted to Everyone because they don't seem to be using Windows permissions with a domain.  It looks like just a file server, peer-to-peer, with everyone attaching as Admin.  I haven't confirmed this with their network person but that is what it looked like to me.

    Monday, August 26, 2013 10:08 AM