SSRS 2019- Users in Browser Role cannot edit their own SSRS subscriptions.

Gajendra Singh 0

Hi, I am using SSRS 2019 version and noticed the issue that users in the Browser role cannot edit their own created subscription. However, they can create and delete their subscription. is there any workaround to allow users to edit their subscription or it's a bug in SQL Server 2019 reporting services?

Gajendra Singh 0 Reputation points

2023-08-05T15:03:00.1433333+00:00

Issue was due to Configuration Options for Setting the To: Field in a Message default <SendEmailToUserAlias>True</SendEmailToUserAlias> .
https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/e-mail-settings-reporting-services-native-mode-configuration-manager?view=sql-server-ver16

2 answers

AniyaTang-MSFT 12,421 Microsoft Vendor

Hi @Gajendra Singh

I created a user "Test" and set it as System user and Browser. I tried creating subscription and modifying subscription, everything works.

Are you showing any error messages? Or is there any error in the log? The log path is generally C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.

Best regards,

Aniya

Gajendra Singh 0

Do you have same 2019 version? Here is error log. If I role to higher privileges then it works. Issue is with Browser role.

|ERROR|129|OData exception occurred: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: A delivery error has occurred. ---> 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 gajendra.singh@companydomain.com.

   at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters, Guid batchId)

   at Microsoft.ReportingServices.Library.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)

   at Microsoft.ReportingServices.WebServer.ReportingService2010.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, String Description, String EventType, String MatchData, ParameterValue[] Parameters)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor

2023-07-21T08:43:23.16+00:00

Hi @Gajendra Singh

Yes, I am using SSRS 2019. And according to the official documentation, the Browser role has the task of managing individual subscriptions. Do you customize the "Browser" role?

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

Best regards,

Aniya
Gajendra Singh 0 Reputation points

2023-07-25T12:02:35.9633333+00:00

Hi @AniyaTang-MSFT , No, I did not customize Browser role. Yes, I checked the link and as per Microsoft documentation individual can manage their subscription but, in our case, getting error if I try to edit my subscription. However, I can create and delete my subscriptions.

Gajendra Singh 0 Reputation points

2023-08-05T15:03:30.3733333+00:00

Issue was due to Configuration Options for Setting the To: Field in a Message default <SendEmailToUserAlias>True</SendEmailToUserAlias> .
https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/e-mail-settings-reporting-services-native-mode-configuration-manager?view=sql-server-ver16
Please sign in to rate this answer.
AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor

2023-08-07T01:24:14.2566667+00:00

Hi @Gajendra Singh

I'm glad your problem was solved. Thank you very much for the questions and answers.

Regards,

Aniya
Sign in to comment

Share via

SSRS 2019- Users in Browser Role cannot edit their own SSRS subscriptions.

2 answers