Use the following procedure to create an OLE DB Data Source object type with the Add Monitoring Wizard. For information about Management Pack templates and the Add Monitoring Wizard, see Management Pack Templates and the Add Monitoring Wizard in System Center Essentials.
To start monitoring an OLE DB Data Source with Essentials 2007
-
Start the Add Monitoring Wizard.
Note
For information about starting the Add Monitoring Wizard, see How to Start the Add Monitoring Wizard in System Center Essentials. -
On the Select Monitoring Type page, select OLE DB Data Source, and click Next.
-
On the General Properties page, do the following:
- Type the Name for the object, such as
Essentials 2007 database.
- Optionally, type the Description for the object.
- Select a Management pack from the list, such as
Default Management Pack, or click New to create a
Management Pack with the Create a Management Pack Wizard.
Note
The object type will be added to the specified Management Pack; therefore, only unsealed Management Packs are listed. - Click Next.
- Type the Name for the object, such as
Essentials 2007 database.
-
On the Enter and Test OLE DB Source Settings page, do one of the following:
- Select Simple Configuration, if it's not already
selected.
- Select a Provider from the list, such as Microsoft
OLE DB Provider for SQL Server.
- Type the IP address or device name, such as
treyresearch.net\Instance1.
- Type the name of the database, such as Essentials.
- Optionally, click Test.
- Click Next.
- Or
- Select Advanced Configuration.
- Type the OLE DB connection string.
Note
The OLE DB connection string for the preceding Simple Configuration is: Provider=SQLOLEDB;Server= treyresearch.net\Instance1;Database=Essentials;Integrated Security=SSPI. For more information about OLE DB connection strings, see http://go.microsoft.com/fwlink/?LinkId=70748. - Click Test.
- When the test succeeds, click Next.
- Select Simple Configuration, if it's not already
selected.
-
On the Choose Watcher Node page, do the following:
- Select one or more agent-managed computers to monitor the
specified OLE DB Data Source.
- Set Run this query every to the desired time; the
minimum is 30 seconds.
- Click Next.
- Select one or more agent-managed computers to monitor the
specified OLE DB Data Source.
-
On the Summary page, review the settings, and click Create.