NetWorker: Module for Microsoft: Unable to retrieve save sets during New Client Wizard for SQL cluster - Error: Referenced object does not exist
Resumen: SQL client creation or backups fail due to missing "Operate NetWorker" privileges for the SQL nodes SYSTEM account.
Síntomas
Using the New Client Wizard to create a client for SQL cluster with windows server failover cluster name - the wizard gets the screen that displays the savesets/db's and gives error:
"unable to retrieve save sets. See nsrsqlsv and nsrnmsqlra logs for more information. Error: Referenced object does not exist."
The NetWorker server's /nsr/logs/daemon.raw reports:
nsrjobd SYSTEM critical User SYSTEM does not have the privileges required to start the requested job. The required privilege is: Operate NetWorker. The job requested to be started is: nsrsqlsv.
Causa
The cluster node's SYSTEM account does not have "Operate NetWorker" privileges and is unable to start nsrsqlsv.
Resolución
The SYSTEM@node_client_name must be added to the NetWorker User Group "Operators". This change can be applied from the NetWorker Management Console (NMC) or from the NetWorker Web User Interface (NWUI). The action plan is the same for both user interfaces.
1. Log in to the NMC or NWUI with the NetWorker Administrator account, or an account with "Application Administrator" and "Security Administrator" privileges.
2. Go to Server->User Groups.
3. Open the Operators user group.
4. In the Users field, add the following entry, using the node client names of the SQL cluster:
SYSTEM@node1_client_name
SYSTEM@node2_client_name
SYSTEM@* or *@* depending on how you want to delegate NetWorker permissions.