A WordPress.com site dedicated to System Center and Cloud Management

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)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Tag Cloud

%d bloggers like this: