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

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'

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.

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

Formerly known as NETIQKB45888