none
Reporting Services in SharePoint

    Pregunta

  • I have a SharePoint performance point site which also hosts reporting services reports

    Sometimes users cannot view these reporting service reports and they see a generic reports error (screenshots below).

    Within the reports server the user access is granted up by adding an active directory group which contains the users id and then granted 'User' privileges to the reports.

    When the issue occurs, I can temporarily resolve it by adding the users id directly to the reports server security page (outside the AD user group) with 'User' access and they can then view the reports without error.

    The strange thing is that if i then remove the users id straight away and leave the original AD group to authenticate they can still view the reports without error ... its as if the reports server security just needs to be refreshed ?

    Any ideas suggestions on cause or how to resolve permanently ?

    -------------------------

    When viewing http://ServerName/Reports I see the below message 

    And when viewing When viewing http://ServerName/ReportServer I see the below message

    miércoles, 14 de marzo de 2012 10:49

Todas las respuestas

  • Hi KarlGregory,

    Which version of operating system client use? If it is later version since Windows Vista/Server 2008, it
    might be caused by UAC configuration. As we may know, when UAC is enabled and we access the report server site, we may get the error said the user has insufficient privilege to access the report server. For the explorer now runs with the least user privileges.

    Currently, we have two workarounds. Please try to disable the UAC, or assign the user permissions in SSRS individually.

    However, I still suggest you submit a wish at https://connect.microsoft.com/SQLServer/,
    and our engineers will take it into consideration.

    We appreciate your understanding.

    Lola Wang



    Please remember to mark the replies as answers if they help.

    viernes, 16 de marzo de 2012 2:46
  • Hi Lola,

    Thank you for your response,

    The reports server is Windows 2003 SP3 and clients access using Windows XP or 7

    We have tired one of the workarounds of adding users directly to the SSRS individually but the issue still occours

    I will submit a request, thanks!

    viernes, 16 de marzo de 2012 17:16