How do I discover an AppManager SQL server agent when using Windows Only Authentication? (NETIQKB12853)

  • 7712853
  • 02-Feb-2007
  • 21-Sep-2010

Environment

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

Situation

How do I discover an AppManager SQL server agent when using Windows Only Authentication?

Error "login failed for user [SQL or NT User] Reason: not associated with a trusted SQL Server connection."

Login failed for user 'sa'

Resolution

The SQL Discovery Knowledge Script defaults to SQL Server Authentication if any user account and password is entered in the Values tab. 

To use Windows (NT) Authentication, leave these fields blank when discovering a SQL server that is set for Windows Only Authentication.  The discovery will be performed with the domain user account that the NetIQmc (Client Resource Monitor) service is running with.

Cause

The NetIQmc (Client Resource Monitor) service on the target SQL server must be running as a valid domain user account that has the SQL Server System Administrator Role under SQL Logins in Enterprise Manager. 

This domain user account can be added to the SQL Logins list, or as a member of the local BUILTIN\Administrators group on the SQL server.  The latter assumes that the default SQL Logins groups have not been modified.

For consistency, the NetIQccm (Client Communication Manager) may also be run with the same domain user account.

Additional Information

Formerly known as NETIQKB12853