Post reply

Access Denied opening up data sources on property of report

  • March 16, 2015 at 8:22 am

    #295138

    I have a user who uploaded a report. The user has the following roles on the folder and report

    Browser, Content Manager, Publisher, Report Builder

    When he goes to the report properties and clicks on data sources to modify the data source, he gets an access denied error.

    What permissions do I need to give him so he can change the data source?

    Thanks!

  • March 25, 2015 at 5:29 am

    #1786226

    Hi,

    In SSRS, if we want to modify the datasource properties, we must have Manage data sources permissions on the report server. So in your scenario, please connect to report server in SSMS, then check if you have select the Manage data sources role for Content Manager.

  • March 25, 2015 at 6:41 am

    #1786264

    Thanks so much for your response. I checked the properties of the content manager role and it does have MANAGE DATA SOURCES checked, as well as everything else.

    In addition, I also asked him to launch IE with RUN AS ADMINISTRATOR, but that didn't help either

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

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