question

DeepakHadpad-8704 avatar image
0 Votes"
DeepakHadpad-8704 asked emilyhua-msft edited

SSRS sharepoint 2013(Manage Subscriptions option missing)

Hi All,

Recently we have done Nov 2020 CU and security patching in SP 2013 farm . Post patching we are facing some issues not actually issue some options are missing under SSRS reports under share point umbrella .

81049-image.png

81094-image.png


For reference i have attached before and after options lists img .

Could anyone let me know how these options can be enabled same ? or what may b the issue that we are not seeing those options ?

Thanks
Deepak


office-sharepoint-server-administrationoffice-sharepoint-server-developmentoffice-sharepoint-server-customization
image.png (47.2 KiB)
image.png (75.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JoyZ avatar image
0 Votes"
JoyZ answered

Hi @DeepakHadpad-8704,

Please go to Central Administration->Site settings->Site collection features, and make sure "Report Server Central Administration Feature" is activated.

Then go to the site collection, and make sure "Report Server Integration Feature" is activated at site collection level.

If you could not see these featues, please run rsSharePoint.msi and repair.

Similar issue for your reference:

https://social.technet.microsoft.com/Forums/office/en-US/1d980e96-4867-4412-9d38-3e34fb7114d3/report-subscriptions-menu-missing?forum=SP2016


If an 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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DeepakHadpad-8704 avatar image
0 Votes"
DeepakHadpad-8704 answered

Hello Everyone,

Is there any update on above issue?

I have tried couple of things but no luck.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

trevorseward avatar image
0 Votes"
trevorseward answered DeepakHadpad-8704 commented

Take a look at the SSRS to SharePoint permissions map and the rights users need to have to perform certain operations. This changed during the SharePoint 2013 timeframe due to potential denial of service attacks.

https://docs.microsoft.com/en-us/sql/reporting-services/security/reporting-services-roles-tasks-vs-sharepoint-groups-permissions?view=sql-server-ver15#bkmk_compare_tasks_permissions

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your response but

The same user and same permission has able view all those options last Monday but why all of sudden not sure .

0 Votes 0 ·

Does the user have the appropriate permission as outlined above? As I said, there was a change at some point during 2013's lifetime to the permissions required to manage subscriptions.

0 Votes 0 ·

Yes user has all appropriate permission . As I told user is able to see all those options two days before .


Hoping this may help deactivate and active report integration mode feature will help .

0 Votes 0 ·