data driven subscription owner change permission issue

Anne 276 Reputation points
2021-02-12T21:07:03.007+00:00

We are using reporting service 2019 Enterprise.

We created a data driver subscription of a report. When we run a subscription, if failed. We found this is because the subscription owner is some other colleague. she runs the subscription fine.

We have to end up to recreate the subscription, the owner becomes the one who created the subscription then it worked.

This creates a lot of work, whenever a new people run the subscription, he has to recreate it.
Is there a way to fix this?

Thanks,

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,849 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. Anne 276 Reputation points
    2021-02-16T17:33:46.533+00:00

    Above answer is the basic security and permissions of SSRS. We have no problem with that.

    The two users we are testing has both system level security and item-level and they are content managers.

    The problem is with the subscription permissions. when a user create a subscription, the owner becomes him/her self automatically. And when the second user run the subscription, it will fail.
    But if the second user create a subscription exactly like the subscription the first user created, it will work.
    The only difference is the owner is different. It looks only user who is the owner can run the subscription.
    We don't want to have to do this and creating multiple subscriptions.

    How to resolve it? Thanks

    0 comments No comments

  2. Joyzhao-MSFT 15,566 Reputation points
    2021-02-15T03:27:29.02+00:00

    Hi @Anne ,
    According to your description, this seems to be a permission issue. In Report Manager, there are two roles: item-level roles and system-level roles.

    • Item-level roles are used to view, add, and manage report server content, subscriptions, report processing, and report history. Item-level role assignments are defined on the root node (the Home folder) or on specific folders or items farther down the hierarchy.
    • System-level roles grant access to site-wide operations that are not bound to any specific item. Examples include using Report Builder and using shared schedules.

    The two types of roles complement each other and should be used together. For this reason, adding a user to a report server is a two-part operation. If you assign a user to an item-level role, you should also assign them to a system-level role. When assigning a user to a role, you must select a role that is already defined. To create, modify, or delete roles, use SQL Server Management Studio. For more information, see Create, Delete, or Modify a Role (Management Studio).

    • You must be a member of the local Administrators group on the report server computer. For more information, see Configure a Native Mode Report Server for Local Administration.
    • To delegate this task to other users, create role assignments that map user accounts to Content Manager and System Administrator roles. Users who have Content Manager and System Administrator permissions can add users to a report server.
    • In SQL Server Management Studio, view the predefined roles for System Roles and User Roles so that you are familiar with the kinds of tasks in each role. Task descriptions are not visible in the web portal, so you will want to be familiar with the roles before you begin adding users.
    • Optionally, customize the roles or define additional roles to include the collection of tasks that you require. For example, if you plan to use custom security settings for individual items, you might want to create a new role definition that grants view-access to folders .

    In your case, the administrator needs to configure the role of the report or the permissions of the folder to which the report belongs, so that the specified user or user group has the authority to run subscriptions. You could refer to the following link for item-level role configuration: To add a user or group to an item role.
    Grant systems and roles ("content administrator" and "system administrator"), please refer to: To add a user or group to a system role.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments