How to deploy and configure OpsMgr 2012 Sp1 – Part 4 – How to Install SQL 2012 Server for Operation Manager Database

Introduction

In this document we will Install SQL 2012 for Operations Manager database. This Database is the Short term Database.

The long Term Database is the Data Warehouse Database, this Database can be Installed on the same server than the Operation Management Database, but in the Series you will install the data warehouse Database on an another Server MTLRS01

Installation

How to Install SQL Server 2012

Setup is fairly straightforward. This document will not go into details and best practices for SQL configuration. Consult your DBA team to ensure your SQL deployment is configured for best practices according to your corporate standards

· On MTLSQL01, open a session with Administrator

· Add the Omadmins Group in the Administrators Local group of the MTLSQL01 Server

clip_image002

· Close the session

· Open a new session with the OMAdmin user

· Click Setup

· Click Installation

clip_image004

· Click New SQL Server stand-alone …..

clip_image006

· Click Show Details

clip_image008

· Validate that all Status are Passed

· Click OK

clip_image010

· Select Specify a free edition if you have an evaluation or if you have a Serial number

· Select Enter the Product Key and type your Product key

· Click Next

clip_image012

· Select I accept the Licence terms If you want to send usage data to Microsoft

· Select Send feature data to Microsoft …..

· Click Next

clip_image014

· If you want to install this Update Select Include SQL Server Setup Update

· Click Next

clip_image016

The update is downloading and installing

clip_image018

· Click Show Details

clip_image020

· Validate that all status are Passed

· Click Next

clip_image022

· Select SQL Server Feature Installation

· Click Next

clip_image024

This server will be used only by the Operations Manager Database. The short time database The SQL reporting Services will be installed on the other server MTLRS01

· Select Database Engine Services

· Select Full-Text and Extraction ….

· Change the Path to D:

· Replace C: by D:

clip_image026

· Select Management Tools Basic

· Select Management Tools – Basic

· This will install all tool needed to manage SQL Server

· Click Next

clip_image028

· Click Show Details

clip_image029

· Validate that the Status is passed

· Click Next

clip_image031

· Select name Instance

· Type OpsMgrOM as Instance Name If you want you can install SQL without any Instance

· Change the Path to D:

· Click Next

clip_image033

· Click Next

clip_image035

For both Service SQL Service Agent and SQL Server Database Engine

· Select the SRVCSQL user. This user is only a Domain User and this user does not have any Administrators right on the SQL Server

This service must be started and automatically

· Select both Startup Type Automatic

· Click the Collation TAB

clip_image037

You can use the default which is SQL_Latin1_General_CP1_CI_AS or choose another supported collation

· Click Next

Note the Collation cannot be changed after SQL installation. It is very important to select the collation that is supported

clip_image039

· Select Windows authentication Mode

· Click Add and Select the OMAdmins Group

· Select Next

Or take our company standard

clip_image041

· Click Next

clip_image043

· Click Show Details

clip_image045

· Validate that all Status are Passed

· Click Next

clip_image047

· Click Install

clip_image049

· Installation is beginning

clip_image051

· Validate that all Status are Succeeded

· Click Close

clip_image053

Validate that you can open SQL

On MTLSQL01 Server, your session is open with OMAdmin user

· Press Windows Key

· Select SQL Server Management Studio

clip_image055

· Select MTLSQL01\OPSMGROM

· Click Connect

clip_image057

· Expand the Server

· Expand Databases

Validate that the 4 Databases are created are mounted

clip_image059

Note

Install the Last Service pack and Cumulative roll up for SQL 2012 before to install OpsMgr 2012

In the Next Document

In the next Document we will install the SQL 2012 Server and the SQL reporting Services

The SQL reporting Services will be used by OpsMgr 2012 Reporting Server Role

This is the Long Term Data Warehouse Database

Cheers,
Alain Laventure
Senior Consultant
Exchange Expert, SCOM Expert and Lync specialist
Allain’s Bio: http://msmvps.com/blogs/andersonpatricio/pages/bio-alain-laventure.aspx

One thought on “How to deploy and configure OpsMgr 2012 Sp1 – Part 4 – How to Install SQL 2012 Server for Operation Manager Database

Leave a Reply

Your email address will not be published. Required fields are marked *