Install and configure SQL Server

Highly-available databases in AlwaysOn Available Groups

I recommend you to use the Microsoft SQL Server 2012 AlwaysOn Available Groups for every System Center products that supports it.

After installation

Highly-available VM with SQL Server

If you do not want to use SQL Server AlwaysOn Available Groups you can simply deploy a separate VM and install SQL Server. But I suggest you to use highly-available databases in AlwaysOn Available Groups even when the installed System Center product is not highly-available.

  • Install as named instance (default instance is also fine for the testing environment).
      • scom0
  • Use service accounts.
  • Set SQL Service Agent to Automatic startup.
      • serscdb0
  • Default collation - SQL_Latin1_General_CP1_CI_AS
  • Security group for the database administrators for the System Center deployment.
      • scdbadmins0
  • Reporting Services - choose Install and Configure in order to install and configure SRS to be active on the server. In production environment in separate installation of the Reporting Services (without DBEngine feature) you would need to do manual configuration of the Reporting Services.
  • Results

Register SPN for the database

You may have set automatic generation of the SPNs but in the case you do not have it because you want for example cluster your SQL Servers then you need to set SPN manually.

Set SPN
  • Register SPN manually:
setspn -s MSSQLSvc/servername.ad.contoso.com DOMAIN\SQLServiceAccount
  • or in the case named instance:
setspn -s MSSQLSvc/servername.ad.contoso.com:instancename DOMAIN\SQLServiceAccount
  • Restart DB server
  • Results
setspn -s MSSQLSvc/contscomdb0.ad.contoso.com:scom0 AD\serscdb0

Install IIS and .NET Framework 3.5 for Web Console

If you decided to use the SCOM Web Console then you need to install Internet Information Services.

  • PowerShell
Add-WindowsFeature NET-WCF-HTTP-Activation45,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Logging,Web-Request-Monitor,Web-Filtering,Web-Stat-Compression,Web-Mgmt-Console,Web-Metabase,Web-Asp-Net,Web-Windows-Auth -Restart

Install the Report Viewer 2012 Runtime

Microsoft Report Viewer 2012 Runtime is a requirement for the SCOM console.

Microsoft System CLR Types for Microsoft SQL Server 2012 (required by Report Viewer)

Microsoft Report Viewer 2012 Runtime (required by SCOM console)

Install Operations Manager

  • Login as member of SCOM Administrators.
  • Install
  • Choose features.
    • For the testing environment I suggest you to install Web console and test it.
    • In the production environment you may want to skip the Web console and install it on a separate server or not install it because you simply do not need it.
  • We are using dynamic memory so the memory warning does not concern us.
  • Create new management group. The name cannot be changed so choose properly and do not use special characters.
      • contosodefault
  • Set DB. Default size of the DB is not enough for the production environment but in our case it is OK.
    • Highly-available databases in AlwaysOn Available Groups
        • contdb1c0agom0.ad.contoso.com
    • Highly-available VM with SQL Server
        • contscomdb0\scom0
  • Data Warehouse
    • Highly-available databases in AlwaysOn Available Groups
        • contdb1c0agomd0.ad.contoso.com
    • Highly-available VM with SQL Server
        • contscomdb0\scom0
  • When SCOM Web Console server should be installed...
    • Web Site
    • User will be logged automatically by its account in AD or he can log manually.
  • Configure Operations Manager accounts
      • AD\serscoma0
      • AD\serscomda0
      • AD\serscomdr0
      • AD\serscomdw0
  •  Install
  • Wait after installation. The SCOM needs time to do all discovery and configuration and it is not a bad idea to give him for example whole night.
  • Do not forgot to install the latest patches.

SCOM console on the management server

Now it is a good time to run the SCOM console from the management server.

  • Install: Microsoft System CLR Types for SQL Server 2012 (required by Report Viewer)
  • Install: Microsoft Report Viewer 2012 Runtime (required by SCOM console)
  • Install Operations console
« Previous Next »

Part of the series

  1. Building Microsoft System Center Cloud - Outline
  2. Building Microsoft SQL Server AlwaysOn Availability Groups - Part 1 - Design