1


we are using SharePoint Server 2016 Farm with 2-WFE,2-Application with Search, and a Database Server (SQL Server 2014). Now I want to Integrate SSRS to SharePoint. Now, MSDN says that SharePoint Server 2016 is supported only SSRS 2016. What should I do now? Is it possible to download and install Reporting Services-SharePoint (2016) separately in Application Server?. But When I tried to install and Configure SSRS 2016 in Single Server Farm (SharePoint 2016 - SQL Server 2014), I have not seen any Content Type with the name of SQL Server Reporting Service Content Types.

enter image description here

Thanks in Advance

  • what problems if i change min role from application to custom . please explain – Suresh K Nov 19 '18 at 6:27
0

As mentioned in the article Supported combinations of SharePoint and Reporting Services server:

  • Combinations that are not list in the following table are not supported
  • SharePoint 2016 support, including Power view integration, requires the Reporting Services report server and the Reporting Services add-in version of SQL Server 2016 or later.

That matches my experience: It's not just a question of "being supported or not". Only the listed product-combinations will work.

0

Finally it's got worked after Change MinRole from Single-Server to Custom. I thought Change Role was required on multi server farm. But even single-server farm also we need to change MinRole.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.