SQL_UserConnections knowledge script returns event error: Login failed for user 'sa'. (NETIQKB10693)

  • 7710693
  • 02-Feb-2007
  • 02-Dec-2010

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager Operator Console
SQL_UserConnections Knowledge Script
Microsoft SQL Server

Situation

SQL_UserConnections knowledge script returns event error: Login failed for user 'sa'.

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.

Cause

The SQL Server login ID, 'sa' was not properly stored in AppManager Security Manager, and/or the login ID is not in the sysadmin Fixed Server Role on the SQL Server.

Additional Information

Formerly known as NETIQKB10693