Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SharePoint 2010 farm that consists of four servers - two WFE servers and two app servers. The WFE servers are the only servers that serve requests to the portal (which is behind a load balancer). The app servers host CA and assorted service applications.

I want to configure SSRS 2008 in SharePoint integrated mode. I already have a SSRS 2008 server built that has an instance of SSRS in non-integrated mode, and I would like to repurpose this server for the SharePoint reporting. My questions are:

1) Do I have to add the SSRS server as a WFE in the existing farm? The documentation claims that I do, but is it possible to have the Reporting Services add-in installed on an existing WFE and then it just points to the SSRS server?

2) If I do need SSRS on a server in the farm, does it have to be a WFE, or can I install it on one of the app servers, keeping in mind that they never serve requests directly to clients?

share|improve this question
add comment

1 Answer

1) You have to make the SSRS server itself a member of your SharePoint farm, just pointing the addin to a standalone SSRS server won't do the trick.

2) You can install it on one of the web tier servers in your farm, it does not have to be on a server in your app tier. Installing SharePoint 2010 on the existing SSRS server does the trick too of course, so you'll end up with 5 servers in your farm.

A nice overview can be found here.

share|improve this answer
    
I'm thinking it will get installed on a WFE...I don't want to add another server to the farm and pay the server tax just to get SSRS up :) –  Matt Stratton Oct 4 '10 at 22:41
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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