Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
Discovery_SQL Knowledge Script
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'
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.
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.
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