Andrew Bancroft • 6/30/2012

Troubleshooting SQL Server 2012 Reporting Services and SharePoint 2010 Integration (Part 1)

This article details troubleshooting steps for integrating SQL Server 2012 Reporting Services (SSRS) with SharePoint 2010 in SharePoint Integrated Mode. The author describes encountering an error when creating a Report Data Source in a Business Intelligence Center site, with messages indicating SSRS functionality is not supported. After investigating, the solution was to install the 'Reporting Services Add-in for SharePoint Products' on all Web Front-End (WFE) nodes of the SharePoint farm, not just the primary server. The article provides practical guidance for resolving this common integration issue.

0 comments

#Sharepoint 2010 #Reporting Services #SQL Server 2012