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 requir​ed 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