none
Can you run multiple Excel Services Applications against a single Web Application? RRS feed

  • Question

  • I have been struggling with this one for a while now, hopefully someone can help me understand what I am missing...

    I have a single SharePoint Farm.  This farm runs multiple Web Applications & the Service Applications.

    1. SharePoint Only Server with Multiple Site Collections (http://sharepoint.com/...)

    2. MS Project Server with Multiple Site Collections (http://pwa.com/...)

    3. My services applications all exist on the same farm.

    I was under the impression, and believe that I validated this through testing and from this site (http://blogs.office.com/2009/11/16/excel-services-in-sharepoint-2010-administration-improvements), that you can only run a single Excel Services Application against each unique Web Application.  In essence, I can run one Excel Services Application against the SharePoint Only Server, and another Excel Services Application against the MS Project Server...  However, I can NOT run multiple Excel Services Applications against the different Site Collections within the MS Project Server becuase it is only aware of its "default" Excel Service Application. 

    ie. I can NOT do the following:  ExcelServiceApp1 for http://pwa.com/SiteA & ExcelServiceApp2 for http://pwa.com/SiteB

    Is that correct?

    If that is not correct, then I must be missing a way to specify a different Excel Service App for each Project Web App Site. 

    Some other solutions that I think may work, but would really appreciate if someone could validate:

    - Create multiple Project Server Service Applications for each instance of PWA/Excel Service? (but wouldn't this still have to use one of the two WebApplications and cause the same limitation?)

    - Create a new Web Applciation for each PWA/Excel Service?  (ie. http://pwasite1.com; http://pwasite2.com; http://pwasite3.com, etc.)

    Thoughts/suggestions are very greatly appreciated!!!

    Monday, June 30, 2014 9:45 PM

Answers

  • Hello Trpy2k

    I have not done what you are doing and I assume that you are using project server 2010.  However, you answer lives in PowerShell.

    The New-WebServiceProxy show that you can create a new proxy by spacing a URL and not a web application. The default proxy from the web application is directing to the default excel service.  If you need another excel service, you must specify another proxy and this may do it for you.

    Also, don't forget the Secure State service and that each excel report will need this configured, that is with the assumption that the other excel service requires different authentication.

    PS.  This question may get a better answer in the SharePoint forums.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries


    Monday, June 30, 2014 10:36 PM
    Moderator

All replies

  • Hello Trpy2k

    I have not done what you are doing and I assume that you are using project server 2010.  However, you answer lives in PowerShell.

    The New-WebServiceProxy show that you can create a new proxy by spacing a URL and not a web application. The default proxy from the web application is directing to the default excel service.  If you need another excel service, you must specify another proxy and this may do it for you.

    Also, don't forget the Secure State service and that each excel report will need this configured, that is with the assumption that the other excel service requires different authentication.

    PS.  This question may get a better answer in the SharePoint forums.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries


    Monday, June 30, 2014 10:36 PM
    Moderator
  • Michael,

    Thank you for the response.  As you guessed, I am using Project Server 2010 (sorry for not including that one before).  I did not realize that I could PS that proxy. 

    Thanks so much,


    T

    Tuesday, July 1, 2014 1:46 PM