Post reply

Allow 'everyone' to view a report

  • July 31, 2017 at 5:47 am

    #343785

    In the past (using SSRS 2008 R2) in order to allow anyone in our organization to VIEW a report. I was able to add  'everyone' under the Security "Add a group or user" at the report folder level.  And the report was made public.  Can I still do this in SSRS 2016?  I added 'everyone' with BROWSER access at the report folder level on our SSRS 2016 instance (I have full rights.. local admin and sysadmin) --- but Users cannot see the report.  Any help is greatly appreciated!

    BT

  • July 31, 2017 at 5:54 am

    #1953353

    ALSO -- the error the user receives is:

    • An error has occurred during report processing. (rsProcessingAborted) 

      • Cannot create a connection to data source 'DBServer_List'. (rsErrorOpeningConnection) 

        • For more information about this error navigate to the report server on the local server machine, or enable remote errors

    NOTE: DBServer_List is the Data Source connecting to the source data...  I thought by granting BROWSER to 'everyone' they'd be able to access this report and it's data

    BT

  • July 31, 2017 at 6:00 am

    #1953354

    If the user couldn't access the report, they would get a different error to that (permission denied). That sounds like the connection to the server isn't working, either because the data source is set up incorrectly, or you're using integrated security and the user doesn't have permission to access the data.

    As you have remote errors off though, you'll need to inspect your logs to get the error.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • July 31, 2017 at 7:27 am

    #1953371

    thanks, yes - that was my issue -- Using Windows Integrated Auth...   I went back and added the appropriate A/D groups as db_datareader on the database itself and it's rendering fine now.  Thanks again for your valuable insight!

    BT

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply