Posted on:
Categories: SharePoint;SQL
Description:

​Deploying Microsoft SQL Server Reporting Services (SSRS) within a SharePoint 2010 environment can be a challenge. It can be particularly confusing when available documentation is not representative of your SharePoint and SQL infrastructure.

Having several clients with multi server SharePoint farms and stand alone SQL servers, the documentation I found never fit these farm topologies and SQL versions I needed for my clients.

What I did not want, was to deploy an extraneous SQL server instance on a SharePoint server,  only to sit idle consuming resources.

I decided to get a definitive map of what components are required where for the SSRS solution to work within a SharePoint 2010 and 2013 environment given a multi server farm topology and 2008, 2012 and 2014 versions of Microsoft SQL.

Below I map the components necessary for the various multi server topologies,  and what components should be installed where.

SSRSInstall2.png 

 OPTIONAL * : This component only needs to be installed if balancing services for redundancy, either SSRS services or Web Application (WFE) services.