locked
Missing the "SQL Server PowerPivot for SharePoint" option RRS feed

  • Question

  • Hello all.

    I'm trying to setup a SharePoint server and have the server installed and trying to install the SQL part.

    I have followed the instructions, but still don't have the option mentioned.

    When I reached the config wiz I got the error that I was missing the SQL. Closed the wiz and continued with the SQL installation.
    Now I can't chose the optionen described in the documentation.

    Info:
    Server 2008 R2 Standard (Installed on a virtual machine on Oracle VM VirtualBox)
    SharePoint 2010
    SQL Server 2008 R2


    Any help appriciated.

    T_admin

    Friday, April 27, 2012 11:35 AM

Answers

  • PowerPivot is not a requirement for doing SharePoint.  Its a very useful Business Intelligence tool, but I have lots of clients that aren't using it.

    Paul Stork SharePoint Server
    MVP Senior Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Friday, April 27, 2012 8:17 PM
  • Hiya,

    If your just looking to get started with SharePoint - SharePoint Foundation(Free) with SQL Express (Free) - is a viable option.

    As with any other application, you should determine which features you need. Below is a list of features for each edition. My general advise to you, is to read some books or take a general introduction course before just trying to understand SharePoint by Point and click.

    http://sharepoint.microsoft.com/en-us/buy/pages/editions-comparison.aspx

    Also a good option is NOT to use the wizard, as you will learn absolutely nothing from it.

    Monday, April 30, 2012 8:18 AM

All replies

  • That option is only available when running SharePoint 2010 Enterprise since it requires the user of Excel Services.  You don't specify which version of SharePoint you are running.

    Also PowerPivot requires either the Enterprise or Datacenter editions of SQL.  You didn't specify that either.  If you don't have both SharePoint and SQL Enterprise or above you won't see the installation option.


    Paul Stork SharePoint Server
    MVP Senior Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Friday, April 27, 2012 12:24 PM
  • Thanks Paul.

    I'm trying to figure out what editions I have.
    I can't access the SharePoint 2010 Admin Center for obvious reasons and can't find the info anywhere else.

    I can't see what edition of the SQL server during the installation either.
    Can you point me in the right direction where to find the info needed?

    EDIT:
    I'm quite sure i have the SQL Server 2008 R2 Express edition.

    Do I really need the 'SQL Server PowerPivot for SharePoint' to get started with SharePoint?
    I got access to a server to "play" with it to learn the basics and as said got stuck in the installation.
    I'm fairly new to the SQL too, but eager to learn.

    T_admin

    • Edited by T_admin Friday, April 27, 2012 1:29 PM
    Friday, April 27, 2012 1:08 PM
  • PowerPivot is not a requirement for doing SharePoint.  Its a very useful Business Intelligence tool, but I have lots of clients that aren't using it.

    Paul Stork SharePoint Server
    MVP Senior Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Friday, April 27, 2012 8:17 PM
  • Hiya,

    If your just looking to get started with SharePoint - SharePoint Foundation(Free) with SQL Express (Free) - is a viable option.

    As with any other application, you should determine which features you need. Below is a list of features for each edition. My general advise to you, is to read some books or take a general introduction course before just trying to understand SharePoint by Point and click.

    http://sharepoint.microsoft.com/en-us/buy/pages/editions-comparison.aspx

    Also a good option is NOT to use the wizard, as you will learn absolutely nothing from it.

    Monday, April 30, 2012 8:18 AM