SSRS permissions issues.

chrisrdba 361 Reputation points
2023-02-03T22:19:54.0633333+00:00

Greetings. I have a group of folks that I want to allow the ability to author reports within specific folders only.

Within the home/ folder1 structure they have the Browser role.

Within the home/ folder1/ custom structure they have all roles possible.

Within the home/ folder1/ custom/ reports folder they are able to upload reports as expected.

Within the home/ folder1/ custom/ there is also a data source named myDS that the group is a member of every role on. So the data source and reports folder has this group at the same "level", with all perms granted to both.

However, they cannot run reports from the reports folder. They get the message "An error has occured during report processing. (rsProcessingAborted) Cannot create a connection to data source 'rptDataSource'. (rsErrorOpeningConnection)".

Note that the data source isn't really named 'rptDataSource', I suspect thats the name that was used in Report Builder before the report was uploaded and pointed to the shared data source.

Any ideas?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
    2023-02-06T07:16:18.1733333+00:00

    Hi @chrisrdba

    Are you doing the right steps to grant user permissions? Please see this link to check your steps for granting permission: https://learn.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-ver16.

    Best regards,

    Aniya

  2. chrisrdba 361 Reputation points
    2023-02-08T17:34:52.55+00:00

    I realized that my next step in this process would be to grant Report Builder to those that need it following the steps outlined here, at which point permissions would need to be elevated far more than I'd ever hoped for, making this exercise pointless.

    That said for non prod I've simply granted everyone System Admin under Site Settings, as well as blanket perms on all folders required. It's just not worth the time to try and do this correctly.

  3. chrisrdba 361 Reputation points
    2023-02-08T17:37:11.86+00:00

    edit -- dup post

    0 comments