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

· Close the session

· Open a new session with the OMAdmin user

· Click Setup

· Click Installation

· Click New SQL Server stand-alone …..

· Click Show Details

· Validate that all Status are Passed

· Click OK

· 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

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

· Select Send feature data to Microsoft …..

· Click Next

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

· Click Next

The update is downloading and installing

· Click Show Details

· Validate that all status are Passed

· Click Next

· Select SQL Server Feature Installation

· Click Next

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:

· Select Management Tools Basic

· Select Management Tools – Basic

· This will install all tool needed to manage SQL Server

· Click Next

· Click Show Details

· Validate that the Status is passed

· Click Next

· 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

· Click Next

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

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

· Select Windows authentication Mode

· Click Add and Select the OMAdmins Group

· Select Next

Or take our company standard

· Click Next

· Click Show Details

· Validate that all Status are Passed

· Click Next

· Click Install

· Installation is beginning

· Validate that all Status are Succeeded

· Click Close

Validate that you can open SQL

On MTLSQL01 Server, your session is open with OMAdmin user

· Press Windows Key

· Select SQL Server Management Studio

· Select MTLSQL01\OPSMGROM

· Click Connect

· Expand the Server

· Expand Databases

Validate that the 4 Databases are created are mounted

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