Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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

I'm installing SQL Server 2008 R2 which would be helpful in

A. querying database.

B. Analysis Services

C. Reporting services and BIDS (SSRS)

D. Powerpivot in Sharepoint

During installation I get two options:

a. SQL Server feature installation: this would install database engine, analysis services, reporting services etc

b. SQL Server for powerpivot for sharepoint: This would be helpful for powerpiviot in Sharepoint. Not sure this option would install all the options mentioned in first option - SQL Server feature installation.

My Question: Which option I should select? If i go for option-a at present, can I later change it to powerpivot option i.e option b.???

share|improve this question

migrated from Dec 9 '12 at 16:20

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

Install the tools you need now, and no others. You can always add more features to the installation later.

If you're not installing reports or PowerPivot into your existing SharePoint installation, don't install them.

When most people say that they want to get "SQL Server" installed, they mean just the database engine. If that sounds like you, install the Database Engine and Management Tools, and you'll have a basic SQL Server up and running.

share|improve this answer
does that mean that I can add Powerpivot later w/o uninstalling SQL Server (what I would be installing now)? – Romil N Dec 10 '12 at 1:16
Yes. You can add that or any of the other components whenever you want. – Dave Markle Dec 10 '12 at 2: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.