Discovery_SQL Knowledge Script reports both success and failure messages. (NETIQKB54906)

  • Document ID:7754906
  • Creation Date:02-Feb-2007
  • Modified Date:10-Jan-2011
    • Micro Focus Products:
      AppManager

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
Discovery_SQL Knowledge Script

Situation

Error: 'SQL_DISCOVERY: ClusterDiscovery - ServVersion3 returned lRetVal=-1 strErrorMsg=[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.'

Error: '[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).'

Resolution

To resolve this issue, you must enable TCP/IP protocol for the desired node and instance that you want to discover. If you are running Microsoft SQL Server on a cluster, you must enable the TCP/IP protocol for the node that is currently hosting the desired Microsoft SQL Server instance.

To enable TCP/IP for Microsoft SQL Server 2000:

  1. In the SQL Client Network Utility, select the General tab.
  2. Select TCP/IP in the Disabled Protocol list.
  3. Click Enable.
  4. Restart the Microsoft SQL Server services.
  5. Rerun the Discovery_SQL Knowledge Script.

To enable TCP/IP for Microsoft SQL Server 2005:

  1. In SQL Server Configuration Manager, expand the SQL Native Client Configuration node. If you are using a 64-bit Microsoft SQL Server, select the node for SQL Native Client Configuration (32-bit).
  2. Click Client Protocols.
  3. Right click on TCP/IP in the right hand pane and select Enable.
  4. Restart the Microsoft SQL Server services.
  5. Rerun the Discovery_SQL Knowledge Script.

Cause

The netiqmc service for the Discovery_SQL Knowledge Script uses NT Authentication and TCP/IP is not enabled in the Client Network Configuration.

Additional Information

Formerly known as NETIQKB54906