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)

One thought on “SQL Server Features

  1. Pingback: Using VHDs to Evaluate System Center 2016 - MiCloud

Share Your Thoughts

%d bloggers like this: