0

Or more specifically, how much of SharePoint needs to be installed on the database server?

I have a SharePoint environment I'm getting ready to move into production but I'm a bit paranoid that the setup isn't quite right. Just fyi, I'm the DBA at my company and I'm not the one who performed the SharePoint install. I was just looking things over before we let the server loose and I noticed that we had running SharePoint services on the SQL Server. This is a multi-farm site with one front end and a database server (not ideal from what I've read but it's all we can do at the moment) so I was curious as to why the database server needed to have SharePoint running on it.

This technet article seems to indicate that some portion of SharePoint needs to be installed on the all of the farm servers (which I assume includes the database) but our database server has multiple SharePoint services running on it as well as it's own databases in the SQL. We're essentially running two SharePoint sites.

My goal is to remove as much of SharePoint from the SQL server as possible without breaking functionality to the actual site. I've gone in and disabled all of the SharePoint services on the database side and the site still functions perfectly well so it seems like they don't need to be there. Can anyone inform me as to what SharePoint features need to be on the SQL or provide some guidance as to how to go about uninstalling SharePoint without causing any harm to the actual site?

|improve this question
4

Simplest answer is: No.

Similar issue (follow first link provided in answer):

SharePoint License for Database Server

Look also at comment by Jesus Shelby

The only exception would be if you are running Reporting Service in integration mode, then you would have SharePoint installed alongside the SQL instance hosting the report server.

|improve this answer
  • Thanks I did see that licensing question as well. I'll read through some of the documents linked there and investigate the Reporting Service point to see if maybe that's why it was installed this way. – Dynamo Sep 28 '11 at 14:41
  • nice catch about Reporting Services. – 1c1cle Aug 22 '12 at 14:46
1

You dont need to install sharepoint on the database server, normal deployments would need 2 servers one for database and the second for the sharepoint components. And the sharepoint components you can also split them acrsoss servers

|improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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