SQL server setup for Operations Manager

From the high level overview of the project, this post will detail how to create the SQL server database for the SCOM01 & SCOM02 Servers.


Pre-requisites to installing SQL server

Create the following accounts for SQL in Active Directory (if they dont already exist):

SQLSVC – for sql services

SQLguy – for sql tasks

SQLBackup – for a backup account to SQL

SQL Server DB01 Build:

Pre-configuration tasks: 

Create the following accounts and groups in Active Directory:

Domain\OMAA  Operations Manager server action account

Domain\OMDAS Operations Manager and Data Access service account

Domain\OMSQL Operations Manager  SQL Service account

Domain\OMAdmins   Operations Manager Administrators Security Group


 Creation of the SQL Server 

Log into DB01 with the following account: Domain\OMAA

Insert/Add the SQL 2012 SP1 ISO. Select your drive and then select Installation. Select New SQL Server stand-alone installation or add features to an existing installation. 

select install

sql server installation center

The Setup support rules will be checked. Select OK to continue.


setup support rules

Enter the license key. Not shown here, if you have a license for SQL server please enter it now, if not use the trial edition. Select Next.

Accept the license terms and select Next.

select accept and next

SQL server license terms

SQL server will now use the windows update agent to check Microsoft for any updates to the SQL install process. In this case I found and update which needed to be installed before installed SQL server.

pre update for sql

pre update for sql

Install the pre-install update for SQL server 2012 SP1.After installed the Setup support roles will be checked before the Installation can proceed. Select Next.

setup support checks

Setup Support Rules

The Setup Role asks what you would like to install for SQL server, select SQL server feature installation.

sql feature install

Make sure that all of the following SQL Services are installed:

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

The only feature I am not installing is the Documentation Components and Distributed Relay Client. Select Next to continue.

what to install1

what to install2

What to install

The installation rules will now be checked. Select Next to continue.

install rules check

Installation Rules

The default SQL Instance is set up. Leave at defaults and select Next to continue.

default instance

Instance Configuration

Check the disk space requirements. The VM is 100GB and will have more than enough space. If not, you can always allocate more space in VMware. Select Next to continue.

disk space req

Disk Space Requirements

On the Server Configuration use the SQLsvc account for the SQL Server Agent, Database Engine, Analysis Services, Reporting Services, and Integration Services. Select Next to continue.

use domain acct for sql

Server Configuration


Make sure the collation is set to the following:

sql server collation

sql server collation

Select Next to continue.

Set up the following accounts as access to the Database Engine:

OMAA, SQLadmin, SQLbackup,sqlguy, OMDAS,OMSQL

DBengine properties

Database Engine Configuration

Set up the following accounts as access to the Analysis Services:

OMAA, SQLadmin, SQLbackup,sqlguy, OMDAS,OMSQL

Select Next to continue.

analysis services

Analysis Services Configuration

Select Install and configure on Reporting Services and select Next.

reporting and config

Reporting services configuration

On error reporting keep the defaults and select Next.

error reporting

error reporting

The Installation Configuration Rules are checked. Everything is working correctly, select Next to continue.

install config rules

Installation Configuration Rules

A ready check of what will be installed to SQL is performed. Select Next to begin the installation.


pre ready chk

Install specs

The install can take up to an hour. After the install you should see the following success screen:


Install Completed

Select Close to Continue.

SQL Server has been installed, now set up your SCOM01 and SCOM02 servers.


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s