Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I was a little confused on this. Our SharePoint 2007 has SharePoint on the backend for some reason? Is this right?

This leads me to believe that I need to install SharePoint 2010 on the backend/database server as well as the web server. Is this true?

share|improve this question

4 Answers 4

up vote 4 down vote accepted

If you have SQL Server Reporting Services in SharePoint 2007 Native Mode, this would have required SharePoint installed on the SSRS server. This is probably why your set up looks like it does - it's much cheaper to install a non-accessible SharePoint instance on your DB server than it is to install a DB instance on one of your WFE machines.

It's just a result of licensing, costs, etc. I'm not entirely sure what the required set up is for using SSRS in SharePoint 2010 so I don't know if this same configuration is required.

*Note that SSRS can really drag down your farm performance if you are using only 1 SQL Server to host the SharePoint Content Databases AND your SSRS instance. It's better to set up a server just to handle the SSRS stuff and leave your other server(s) to handle just SharePoint related tasks. Just a random aside based on observations.

This blog post discusses the server configuration for Report Services and SharePoint. Look at 03 - Available Server. http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html

share|improve this answer
1  
Yes you do need it on both servers for SharePoint 2010 msdn.microsoft.com/en-us/library/bb510781.aspx –  Mike Jul 21 '11 at 20:33

If the database server is also going to be included in serving content and or serve in an application role, then you'd install SharePoint on that as well. Otherwise, no, you shouldn't be needing to install it on the DB server.

share|improve this answer

No, you don't need to install anything to do with SharePoint on your database tier (nor should you). It just needs to be running SQL Server and have good network bandwidth and latency to the other servers in your farm.

This is true for both 2007 and 2010 versions of SharePoint.

share|improve this answer
1  
That's true for an environment not using Integrated SSRS. To use SSRS in SharePoint 2007 you have to have the SharePoint installed on the SSRS server in order for SSRS to access the SharePoint Object Model. –  Erik Noren Jul 21 '11 at 17:41
    
Okay, agreed, in the event that you are using Reporting Services integration, you need an application server in your farm with the Report Server installed and SharePoint because of the OM. You could make your database server double up as an application server to achieve this. But that's not the same as saying you necessarily have to install SharePoint on your data tier. –  SPDoctor Jul 21 '11 at 18:50
    
Agreed. The questions was sufficiently short I took put a little of my own bias on it and assumed 1 SQL Server + 2 or 3 WFE. Seems fairly standard for smaller shops. The same limits would lead to "just install SharePoint on the DB and it will just work(TM)" with SSRS. –  Erik Noren Jul 21 '11 at 19:13

Did your devs mean the following?

install just the central admin and application servers on the backend (not being accessible by inter/intranet). Only make the web frontends publicly available. This is security-wise smart to do. SharePoint is not needed on the database server, if the the database server's only role is to, euh, be a database server :)

share|improve this answer

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.