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

This article provides a detailed troubleshooting guide for resolving a common error when integrating SQL Server 2012 Reporting Services (SSRS) with SharePoint 2010 in Integrated Mode. The author describes encountering an error when adding a Report Data Source in a Business Intelligence Center site, with messages like 'This SQL Server Reporting Services (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 explains the symptoms, the misleading error messages, and the step-by-step fix, emphasizing that the add-in alone is sufficient on additional nodes without reinstalling the full SSRS or database engine.