Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > ipMonitor > Troubleshoot ADO monitors

Troubleshoot ADO monitors

Table of contents
Created by Norsolihati Selamat, last modified by Rodim Suarez on Aug 31, 2016

Views: 14 Votes: 0 Revisions: 3

Overview

This article describes how to troubleshoot ADO monitors.

Environment

All IPMonitor versions

Steps

  1. To test connectivity and authentication to an SQL server (MS SQL, Oracle, MySQL, etc), create a UDL file on the ipMonitor host.
    Note: If a 64-bit OS, UDL file must be started using 32-bit ODBC. To do this, use following command: C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl
  2. Select Provider, provide Connection information and click test option.
  3. If test is successful, close Data Link Properties and open UDL file in notepad. Use connection string to populate ADO Monitor.
  4. If test fails, it is recommended to seek assistance from your DBA or technical support for further investigation.

 

Last modified
22:03, 30 Aug 2016

Tags

Classifications

Public