Discovery_SQL fails with Error 'Discovery is not Applicable'. (NETIQKB44784)

  • 7744784
  • 02-Feb-2007
  • 05-Apr-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
Microsoft SQL Server 2000 SP3

Situation

Discovery_SQL fails with Error 'Discovery is not Applicable'.

Resolution

To save the sa password for the particular SQL server with the Save SQL password mechanism:

  1. Go into the AppManager Operator Console
  2. Pull down the Extension menu.
  3. Select Save SQL password.
  4. Select the appropriate computer name.
  5. Enter sa as the SQL login.
  6. Enter the SQL password appropriately.
  7. Click on Save.
To save the sa password through the AppManager Security Manager:

  1. Go into AppManager Security Manager.
  2. Select the SQL server computer name which returns the error upon discovery of SQL.
  3. Click on the SQL tab.
  4. Enter the SQL sa password.
  5. Click logon.

Finally,  if you are using the LocalSystem account on the NetIQ Client Resource Monitor and the Client Communication Manager (on the targeted Agent client), you must have the Builtin administrators group in SQL with permissions to the Databases.  Otherwise, you must specify a valid Windows NT account as the service account with the appropriate database permissions.

Cause

Incorrect SQL credentials were supplied for the Knowledge Script.

Additional Information

Formerly known as NETIQKB44784