SSRS Subscription privileges

Question

I have created a lot of subscriptions (as administrator).
Then i used powershell scripts to modify the owner of these subscriptions.
None of the new owners are administrators.

If a new owner wants to change anything in their subscription, they will receive an error message: "a delivery error has occured"

SSRS logfile entry therefore:

library!ReportServer_0-15!1b24!10/30/2020-06:53:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.DeliveryErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.DeliveryErrorException: A delivery error has occurred. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidExtensionParameter: One of the extension parameters is not valid for the following reason: The account you are using does not have administrator privileges. A subscription cannot be created for xxx.yyy@zzz.com.

The new owner still needs administrator privileges !

My questions are:

Why administrator privileges
Where and how to modify that

Any help welcome
Volkmar

Answer 1

Hi @Volkmar Jaeger ,

If the new owner doesn't have the permission as a Content Manager role, he/she couldn't modify the subscription settings.

Owner could delete the subscription or run the subscription with minimum privilege.

If he/she doesn't have the permission to modify the report, he/she couldn't change change anything in their subscriptions.

Please refer:

https://learn.microsoft.com/en-us/sql/reporting-services/security/role-definitions-predefined-roles?view=sql-server-ver15

https://learn.microsoft.com/en-us/sql/reporting-services/security/tasks-and-permissions-item-level-tasks?view=sql-server-ver15

Grant correct permissions to the new owner could resolve the issue easily.

https://learn.microsoft.com/en-us/sql/reporting-services/security/granting-permissions-on-a-native-mode-report-server?view=sql-server-ver15
Regards，

Zoe

---

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.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November