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

I am configuring SSRS (2008 R2) in SharePoint integrated mode to work with a SharePoint (2010) site that is on another server, do I also have to install SharePoint on the database server that is hosting SSRS? I should note that the SharePoint databases are also on the database server that is hosting SSRS.

share|improve this question
    
I think I answered my own question, you do have to have SharePoint installed on the SSRS server because it uses the SharePoint Object Model to serve the reports in integrated mode ('Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c') –  Infotekka Jan 21 '11 at 18:40

1 Answer 1

up vote 1 down vote accepted

You need to install SharePoint and SSRS on the same machine. This does not need to be the same machine which has the actual databases on it (in fact it usually will not be the same machine).

share|improve this answer
    
[Insert forehead slap here] Of course! I was thinking about htis backwards all along, I shouldn't be installing SSRS on the database server at all. Thanks! –  Infotekka Jan 21 '11 at 23:52

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.