Operator Console shows Auto Discovery failures when adding new computers. (NETIQKB45888)

  • 7745888
  • 02-Feb-2007
  • 24-Jan-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

Operator Console shows Auto Discovery failures when adding new computers.

Rplib.log displays an error message similar to the following:

ERROR: 'EXECUTE permission denied on object 'CreateMachine', database 'QDB', owner 'dbo'.'
02/22/05 13:00:42 (NetIQms-4.6.2000.134 pid 976, th# 4816) {?=calldbo.FetchMachineObjID (?,?)}02/22/05 13:00:42 (NetIQms-4.6.2000.134 pid 976, th# 4816) SQLSTATE=37000,native error=50000, msg='[Microsoft][ODBC SQL Server Driver][SQLServer]FetchMachineObjID: Not exists objid of machine SERVER'
02/22/05 13:42:30 (NetIQms-4.6.2000.134 pid 3864, th# 5680) {?=calldbo.CreateParentJob (?,?,?,?,?,?,?,?,?,?,?,?,?,?)}02/22/05 13:42:30 (NetIQms-4.6.2000.134 pid 3864, th# 5680) SQLSTATE=42000,native error=229, msg='[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTEpermission'

Resolution

The user logged onto the Console must have additional permissions execute the following stored procedures:

SP_CreateMachine
SP_CreateUser

To ensure that the user has the permissions necessary to execute the required stored procedures, do one of the following:

  • Grant the user sa or equivalent rights on the AM Repository Database (QDB, by default).
  • Ensure the account has the necessary permissions to execute stored procedures in SQL.  Also, ensure the Management Server is registered using an sa equivalent account.

Cause

The Management Server account and/or the account used to log into the Console does not have sufficient permissions to execute a stored procedure.

Additional Information

Formerly known as NETIQKB45888