When creating a PowerPivot Service Application I am giving two options: "Use existing application pool" or "Create new application pool" and if I join an existing pool which one
should it be "SharePoint Web Services Default" or "SharePoint Web Services System"?
Now I understand isolation and other technical reasons but what I want to understand is what you guys in the field that run SharePoint Farm would want me to configure and if that
does not cause me any scale or performance issue we are good. If I want to run outside most SharePoint standards I better have a good reason.
One note I just missed was: "While this may be a good security best practice, you may still want to use an application pool and/or managed account that is tied to your SharePoint
Farm account. As will be noted in Chapter 9, for the PowerPivot data refresh feature to work, the PowerPivot Service Application and PowerPivot System Service requires Farm account rights to access the Secure Store Service database." -- PowerPivot for Excel
and SharePoint, page 217
So folks what you would suggest or better yet, how would you like it configured within your farm.
View Complete Post