IT33349: "LOG ON AS A BATCH JOB" SECURITY POLICY SETTING IS MISSING FROM MICROSOFT SQL SERVER DATABASE BACKUP AND RESTORE REQUIREMENTS

APAR status

• Closed as documentation error.

Error description

• The Windows Task Scheduler is used to schedule log backups.
  Depending on the environment, users might receive the following
  error:
  
  This task requires that the user account specified has Log on as
  batch job rights...
  
  This behavior occurs when the registered SPP user is not
  assigned to a group or directly assigned with "Log on as batch
  job" permission. This right needs to be added to Microsoft SQL
  Server database backup and restore requirements document. To
  enable "Log on as batch job" permission, Local Security Policy
  can be edited as described in following link:
  
  https://docs.microsoft.com/en-us/windows/security/threat-protect
  ion/security-policy-settings/log-on-as-a-batch-job
  
  Versions affected: 10.1.*
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus Knowledge Center and User's Guide  *
  * in version 10.1.5 and version 10.1.6.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The missing requirement of Client for Microsoft Networks was
  added in IBM Spectrum Protect Plus User's Guide and requirements
  for versions 10.1.5 and 10.1.6. The following topics were
  updated to indicate this requirement:
  https://www.ibm.com/support/knowledgecenter/SSNQFQ_10.1.5/spp/r_
  spp_system_reqs_sql.html
  https://www.ibm.com/support/knowledgecenter/SSNQFQ_10.1.6/spp/r_
  spp_system_reqs_sql.html
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels