man thinking

SharePoint 2010 Service Applications

Mother and boy - 50s advertising

I can never remember which of those pesky Service Applications support cross-farm publishing (federation), which ones can be partitioned, and so on. So here's a handy table to cut out and keep, showing each one and what it can do.

In order to create a neat, compact table I have had to make up some abbreviated headings. So 'Cache' means the data is cached somewhere, 'DB' means it has its own database and 'SKU' indicates the minimum version of SharePoint required for the service application. 'Fed' means that it can be federated to other farms, 'Part' means that it can be used in partitioned mode (multi-tenant) and 'TD' indicates whether the service application stores tenant data.

Service ApplicationFedPartTDDBCacheSKU
Access Services  Enterprise
Business Data Connectivity     Foundation
Excel Services  Enterprise
FAST for SharePoint   Enterprise + FAST
InfoPath FormsEnterprise
Managed Metadata     Standard
PerformancePoint  Enterprise
PowerPoint  Enterprise
Project    Enterprise + Project
Search     Standard
Secure Store     Standard
Security Token ServiceFoundation
State Service  Standard
Subscription Settings    Foundation
Usage and Health Data Collection   Foundation
User Profile     Standard
Visio Graphics  Enterprise
Web Analytics   Standard
Word Automation   Standard
Word Viewing  Foundation