SHARE
Facebook X Pinterest WhatsApp

SQL Server and MOM 2005

Dec 28, 2005

In this series of articles, you will learn the basics of
installing Microsoft Operations Manager 2005 as well as how to use MOM to
monitor SQL Server. This article takes advantage of virtualization. We will use
VMware Workstation 5 to create the lab to introduce you to the basics of
installing MOM to monitor SQL Server. This series will be broken into the
following two parts:

  • Installing MOM 2005
  • Monitoring SQL Server with MOM 2005

Our lab will consist of three virtual machines as shown in
Figure A. Please remember that you must have these three virtual machines
networked and connected to the virtual domain. Instructions on how to network
your virtual machines and connect them to the virtual domain controller are
outside the scope of this article.

Click for larger image


Figure A.

Installing the MOM User Interfaces on the Domain Controller

In order to install the MOM user interfaces, select the MOM
2005 setup icon. This will launch the install wizard. Next, click Install
Microsoft Operations Manager 2005 (Figure B). Accept the License Agreement and
choose a Custom installation. On the Custom installation window, make sure you
only select MOM 2005 User Interfaces (Figure C). Once the installation is
finished, click the Finish button and deselect the checkbox to Start the MOM
Administrator Console (Figure D).

Note: In order to make sure you meet the minimum
requirements for you virtual lab, make sure to use the Check Prerequisites
utility located on the cd-rom (Figure B).

Click for larger image


Figure B.



Figure C.



Figure D.

Installing the MOM Database on the DB Server

In order to install the MOM database you need to have the
following installed:

  • Windows 2003
  • SQL Server 2000 SP 3a or greater
  • SQL Server Reporting Services
  • .Net Framework 1.1

Note: In order to make sure you meet the minimum
requirements for your virtual lab, make sure to use the Check Prerequisites
utility located on the cd-rom (Figure E).

Now that you have the minimum requirements, select the MOM
2005 setup icon. This will launch the install wizard. Next, click Install
Microsoft Operations Manager 2005 (Figure B).

Walk through the wizard and choose a Custom Installation. On
the Database server, only select MOM 2005 database. Deselect all other
components (Figure E). The installation will now make sure you pass all of your
prerequisites and prompt you to choose your SQL Server database instance.



Figure E.



Figure F.

On the Database and Log File Option window, you can choose
your database size. For purposes of this article, we are going to keep the
database size small and choose 400 MB (Figure G). On the Management Group Name
window, provide a name for your MOM components, and agents as shown in Figure
H. Now you are ready to provide a data access server account as shown in Figure
I. You can now work through the remaining defaults and begin the installation.



Figure G.



Figure H.



Figure I.

SW

Steven S. Warren is a popular author residing in Winter Haven, Florida with his wife Danna and 2 children: Catie-Charlotte and Dain. As a columnist on such well-known IT web sites as Techrepublic.com, CNET, and ZDNET, Steven has published numerous articles. Additionally, Steven holds the following certifications: MCDBA, MCSE, MCSA, CCA, CIW-SA, CIW-MA, Network+, and I-Net+. As a Senior Technical Consultant for The Ultimate Software Group, Steven has become an expert at administering Microsoft networks including Microsoft SQL Server. He is also a computer hardware and troubleshooting expert, and is constantly seeking out new technologies and certifications. Additionally, Microsoft recently awarded him the Most Valuable Professional (MVP) award for his outstanding achievements. Steven resides in Winter Haven, Fl.

Recommended for you...

Best Courses for Database Administrators
Ronnie Payne
Jul 22, 2022
Tip 74 – Changing Cost Threshold for Parallelism
Gregory Larsen
Feb 24, 2021
How Many Databases Can You Name?
Brad Jones
May 11, 2020
Database Journal Logo

DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.

Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.