1. 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.

2. On the Select Monitoring Type page, select OLE DB Data Source, and click Next.

3. On the General Properties page, do the following:

   1. Type the Name for the object, such as Essentials 2007 database.
      
      
   2. Optionally, type the Description for the object.
      
      
   3. 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.

   4. Click Next.
      
      

4. On the Enter and Test OLE DB Source Settings page, do one of the following:

   1. Select Simple Configuration, if it's not already selected.
      
      
   2. Select a Provider from the list, such as Microsoft OLE DB Provider for SQL Server.
      
      
   3. Type the IP address or device name, such as treyresearch.net\Instance1.
      
      
   4. Type the name of the database, such as Essentials.
      
      
   5. Optionally, click Test.
      
      
   6. Click Next.
      
      
   7. Or
      
      
   8. Select Advanced Configuration.
      
      
   9. 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.

   10. Click Test.
       
       
   11. When the test succeeds, click Next.
       
       

5. On the Choose Watcher Node page, do the following:

   1. Select one or more agent-managed computers to monitor the specified OLE DB Data Source.
      
      
   2. Set Run this query every to the desired time; the minimum is 30 seconds.
      
      
   3. Click Next.
      
      

6. On the Summary page, review the settings, and click Create.

Other Resources