Knowledge Center > Tips

ipMonitor includes two Monitor types that make use of ActiveX Data Object technology: the ADO Monitor and the ADO - QA Monitor. These Monitors allow you to test database connectivity. In addition, the ADO - QA Monitor is able to perform a query and test the returned results.

It is likely that a Credential will need to be created and assigned to an ADO-based Monitor for it to connect successfully to a data source. The following Usage Restrictions options are available when creating a Credential:

• May be used over SSL
• May be used with Digest Authentication Schemes
• May be used with NTLM Authentication Schemes (Windows NT Lan Manager)
• May be used with Windows Impersonation for use with RPC
• May be used with Windows Impersonation to start an external process
• May be used with ADO (ActiveX Data Objects)
• May be used to encrypt data
• May be transmitted in clear text

Note: With increased security in mind, it is highly recommended that only the required Usage Restriction options are selected when creating a Credential.

Monitor settings for a Microsoft SQL Server 2000 connection:

1. For a Standard Security (SQL Authentication) connection:
   • Provider = sqloledb
   • Data Source = ServerName
   • Initial Catalog = DatabaseName
   Required Credential Usage Restrictions options:
   • May be used with ADO (ActiveX Data Objects)
2. For a Trusted Connection (NT Authentication):
   • Provider = sqloledb
   • Data Source = ServerName
   • Initial Catalog = DatabaseName
   • Integrated Security = SSPI
   Required Credential Usage Restrictions options:
   • May be used with Windows Impersonation for use with RPC
3. For a connection to a Named Instance of SQL Server 2000:
   • Provider = sqloledb
   • Data Source = ServerName\InstanceName
   • Initial Catalog = DatabaseName

The Credential Usage Restrictions options and additional parameters required will depend on whether the Named Instance uses SQL Authentication or NT Authentication (please refer to Examples 1 and 2).
Note: In order to connect to a SQL Server 2000 Named Instance, you must have MDAC 2.6 (or greater) installed.

4. For a TCP/IP connection to a remote SQL Server 2000:
   • Provider = sqloledb
   • Network Library = DBMSSOCN
   • Data Source = xxx.xxx.xxx.xxx,1433
   • Initial Catalog = DatabaseName

The Credential Usage Restrictions options and additional parameters required will depend on whether the SQL Server Instance uses SQL Authentication or NT Authentication (please refer to Examples 1 and 2).
Note: The Network Library = DBMSSOCN parameter indicates TCP/IP should be used instead of Named Pipes. The default port number for SQL Server 2000 is 1433.

In order to use the ADO and ADO - QA Monitor types, the appropriate OLE DB Providers must be installed on the ipMonitor host machine.

For information on other features and concepts related to those discussed in this article, refer to the following ipMonitor resources:

< Back

Last Updated: April 19, 2006 | What did you think of this topic?