Unable to Access Subscription present on a Reporting Services Report (SSRS Report)

Abhay Sharma 0 Reputation points
2023-06-01T00:10:06.98+00:00

Hi! I am having an issue with a SSRS report subscription. When I open the subscription by clicking on edit it gives me an error like in the screenshot below, The ownerID or the user that was used to create this subscription previously was a personal account of an ex-employee at our organization. Since the employee is no longer with the firm, his User ID got deactivated, due to which I believe we are getting this issue. I have changed the ownerID to a service account by updating it in the backend execution log. This service account or new OwnerID has full access to the server and the Datasource that is being used in the report. I am still facing this issue. Please let me know how we can fix this issue as the subscription is not running and I am not able to see any details in the subscription like schedule time or recipient list.

We need to fix this asap, could you please look into it on a high priority, as we getting impacted on the production server.

User's image

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,226 Reputation points
    2023-06-01T02:34:02.13+00:00

    Hi @Abhay Sharma,

    SSRS system admin user can manage all the subscriptions (created by other users too).

    Please try to use the admin user to manage the subscription or make sure that your account has the permission to manage the subscription.

    User's image

    In addition, if this impact on the production server, you may open a ticket to Microsoft to get the respond promptly.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments