Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager Operator Console
SQL_UserConnections Knowledge Script
Microsoft SQL Server
Situation
Resolution
One of the parameters for the SQL_UserConnections Knowledge Script is for a login account to access SQL Server. This account must have been set up in the managed client's SQL Server and been given permission to run SQL Server Knowledge Scripts through the AppManager Security Manager, or using save SQL password within the operator console.
For the SQL Server 'sa' account to be used, the 'sa' password needs to be saved in the AppManager Security Manager.
See https://www.netiq.com/kb/esupport/consumer/esupport.asp?id=NETIQKB4833 for information on how to change the sa pasword in the AppManager Security Manager.
To Access the Save SQL Password feature open the NetIQ AppManager Operator Console.
Goto Extensions > Save SQL Password
Define the Computer, the SQL Server Instance, and the SQL Login Information. Choose Save.