SQL Server Reporting Services Content Types are not provisioned when a new site is created.

Walter Curtis
Walter Curtis used Ask the Experts™
on
SharePoint 2016 Farm - 16.0.4771.1000

After installation of recent SharePoint update KB4461501, when a new site collection is provisioned, although the feature "Report Server Integration Feature" is active, the SQL Server Reporting Services Content Types are not provisioned / installed. Any ideas about how to correct this situation?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> After installation of recent SharePoint update KB4461501

Seems like some permissions are reset as part of the update..
Kindly try provisioning again properly with the help of below document and ensure the account running SSRS and SQL Server Agent have enough privileges.
https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/provision-subscriptions-and-alerts-for-ssrs-service-applications?view=sql-server-2016
Walter CurtisSharePoint AED
Distinguished Expert 2018

Author

Commented:
Thanks for the information and suggestion.  Answer and question were different topics, but appreciate the effort.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> Answer and question were different topics

Can you kindly explain your needs if I misunderstood out so that I can try to provide more details..
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Walter CurtisSharePoint AED
Distinguished Expert 2018

Author

Commented:
Thanks I appreciate you getting back to this. I was referring a newly created SharePoint site not having the SSRS SharePoint content types while existing sites were working correctly.

I think the way I asked the question was not very good.

Thanks and have a good one...
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Oh, okay..
Thanks, request you to provide complete details going forward so that experts can guide you more appropriately.
Walter CurtisSharePoint AED
Distinguished Expert 2018

Author

Commented:
Will do - thanks for the feedback...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial