locked
Excel Services App RRS feed

  • Question

  • I am trying to install Power Pivot for my existing Sharepoint Server 2010 Enterprise version. I understand that I would need to enable Excel Services and use Classic Mode authentication as Prerequisites.

    1. I am unable to create an new "Excel service app" from central administration simply because it does not give me the option in the dropdown.

    2. I have Claims Based Authentication on my web application and I was wondering how I can convert this to classic mode and  If I do would there be any repercursions.


    Friday, January 20, 2012 1:47 PM

Answers

  • Naveen,

    To my knowledge, it is not possible to convert it back to classic mode.

    I guess you could use backup & restore to get the data back, but there is no OOTB way to convert an existing web app back to classic authentication.


    Kind regards,

    Nico Martens - MCTS, MCITP
    SharePoint 2010 Infrastructure Consultant
    Blog: SharePoint Related
    E-mail: Nico Martens
    • Marked as answer by GoingForward Friday, January 20, 2012 2:51 PM
    Friday, January 20, 2012 2:12 PM
  • Hi Naveen,

    Yes, you are right. It is installed, but this is by design.

    There are 2 "installers" available for SharePoint 2010.

    - SharePoint 2010 Foundation

    - SharePoint 2010 Server

    The latter one contains both the Standard and Enterprise features, but the Enterprise features are only activated when you enter an Enterprise license.

    You can upgrade from Standard to Enterprise without reinstalling SharePoint.

    I hope this helps.


    Kind regards,

    Nico Martens - MCTS, MCITP
    SharePoint 2010 Infrastructure Consultant
    Blog: SharePoint Related
    E-mail: Nico Martens
    • Marked as answer by GoingForward Friday, January 20, 2012 2:50 PM
    Friday, January 20, 2012 2:41 PM

All replies

  • Hi Naveen,

    Excel Services is part of the Enterprise edition of SharePoint.

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


    Kind regards,

    Nico Martens - MCTS, MCITP
    SharePoint 2010 Infrastructure Consultant
    Blog: SharePoint Related
    E-mail: Nico Martens
    Friday, January 20, 2012 1:49 PM
  • Nico Martens

    This is embarassing. I completely overlooked the licensing. Thanks

    However, is there a solution to my second question.

    "2. I have Claims Based Authentication on my web application and I was wondering how I can convert this to classic mode and  If I do would there be any repercursions."

    Friday, January 20, 2012 2:06 PM
  • Naveen,

    To my knowledge, it is not possible to convert it back to classic mode.

    I guess you could use backup & restore to get the data back, but there is no OOTB way to convert an existing web app back to classic authentication.


    Kind regards,

    Nico Martens - MCTS, MCITP
    SharePoint 2010 Infrastructure Consultant
    Blog: SharePoint Related
    E-mail: Nico Martens
    • Marked as answer by GoingForward Friday, January 20, 2012 2:51 PM
    Friday, January 20, 2012 2:12 PM
  • Thanks. I knew that the other way is possible, but doubted this as well.

    I apologize Nico, but just going back to question 1.

    I figured I do have a Standard license and conventionally Excel Services does not come bundled. However it looks like microsoft Excel Services are installed on the server, when I checked from central admin.



    Friday, January 20, 2012 2:37 PM
  • Hi Naveen,

    Yes, you are right. It is installed, but this is by design.

    There are 2 "installers" available for SharePoint 2010.

    - SharePoint 2010 Foundation

    - SharePoint 2010 Server

    The latter one contains both the Standard and Enterprise features, but the Enterprise features are only activated when you enter an Enterprise license.

    You can upgrade from Standard to Enterprise without reinstalling SharePoint.

    I hope this helps.


    Kind regards,

    Nico Martens - MCTS, MCITP
    SharePoint 2010 Infrastructure Consultant
    Blog: SharePoint Related
    E-mail: Nico Martens
    • Marked as answer by GoingForward Friday, January 20, 2012 2:50 PM
    Friday, January 20, 2012 2:41 PM
  • I appreciate the quick response. It was very helpful.

    Thanks a lot!

    Friday, January 20, 2012 2:50 PM