SQL Server Features

I thought that I would make it easy for everyone and have a page showing the different SQL Server features I install for each System Center product.

As I write the various guides for each specific product, I will update this page to include the SQL Features I use for each of the VMs. That way I can keep the generic guides (i.e. System Center 2012 SP1 in a LAB – Installation Part A to Part D), well, generic.

System Center App Controller (SCAC):

• Database Engine Services
• Management Tools – Basic and Complete (for running queries and configuring SQL services)

System Center Data Protection Manager (SCDPM):

• Database Engine Services
• SQL Server Replication
• Full-Text and Semantic Extractions for Search
• Reporting Services – Native
• Management Tools – Basic and Complete (for running queries and configuring SQL services)
• SQL Client Connectivity SDK

System Center Operations Manager (SCOM):

• Database Engine Services
• Full-Text and Semantic Extractions for Search
• Reporting Services – Native
• Analysis Services (see SCVMM Forecasting Analysis Reporting guide)
• Management Tools – Basic and Complete (for running queries and configuring SQL services)

System Center Orchestrator (SCORCH):

• Database Engine Services
• Management Tools – Basic and Complete (for running queries and configuring SQL services)

System Center Service Manager (SCSM):

SCSM Management Server:

• Database Engine Services
• Full-Text and Semantic Extractions for Search
• Management Tools – Basic and Complete (for running queries and configuring SQL services)

 SCSM Warehouse Server:

• Database Engine Services
• Full-Text and Semantic Extractions for Search
• SQL Server Reporting Services (SSRS)
  • Collation: SQL_Latin1_General_CP1_CI_AS
• SQL Server Analysis Services (SSAS)
  • Collation: Latin1_General_100_CI_AS
• Management Tools – Basic and Complete (for running queries and configuring SQL services)

System Center Virtual Machine Manager (SCVMM):

• Database Engine Services
• Management Tools – Basic and Complete (for running queries and configuring SQL services)