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
Nice article, but where is part 5?