Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 28, 2005

SQL Server and MOM 2005 - Page 2

By Steven Warren

Installing the Management Server

Your first step is to 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 the Management Server components. Deselect all other components (Figure J). Next, enter the name of the MOM Database server and continue (Figure K). Finally, supply your account credentials and the appropriate licensing and click the Install button as shown in Figure M.

Installing the MOM Agent on the Domain Controller

We are now ready to install the MOM agents. To install the agents, click Start | All Programs | Microsoft Operations Manager 2005 | Administrator console (Figure N). You will be required to enter the name of the Management server. Next, Click Install Agents and choose the Method for Discovering Computers and Installing Agents. We will choose Browse for or type in specific computer names (Figure O). Now you will specify the accounts used to install the agents and accept remaining defaults to install the Agents.

Figure N.

Figure O.

Install System Center Reporting on the Database Server

In order to install the System Center Reporting, select the MOM 2005 setup icon. This will launch the install wizard. Next, click Install Microsoft Operations Manager 2005 Reporting. You can simply accept the default when working through the wizard and allow the virtual directories to be automatically detected (Figure P). Other options you need to enter are the MOM database server name, database size, and account credentials.

Figure P.

In our next articles, we will import the SQL Server 2000 Management Pack and Reports and help you become familiar with monitoring SQL Server via MOM 2005.

» See All Articles by Columnist Steven S. Warren

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM