SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?

share|improve this question
up vote 2 down vote accepted

You just need the Database Engine Services (not even its children features). The management tools (basics) are recommended to quickly & visually manage your instance but they can be installed on a separate machine.

Anything else is optional and not required / used by SharePoint Foundation 2010 and it's always a good practice to limit your installation to the few features that are mandatory.

sql server 2008 R2 Features

share|improve this answer
Thanks for your answer. Much appreciated. – Joseph Caruana Feb 16 '13 at 20:18
glad I was able to help. – Francois Verbeeck Feb 17 '13 at 8:54

Your Answer


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.