Solved

why local administrator role is required for service account for SQL backup?

  • 20 October 2022
  • 1 reply
  • 780 views

Badge +4

https://documentation.commvault.com/v11/essential/104420_user_account_configuration_for_sql_server_solution.html

 

From this link local admin role is required for SQL backup. is there a reason for this?

The reason I asked is because administrator can do a lot of things and it seems a bit overkill for SQL backup only.

 

Kind regards,

Boyi Ou

icon

Best answer by Scott Reynolds 20 October 2022, 16:34

View original

1 reply

Userlevel 6
Badge +14

Hello @Boyi 

You are correct the account must be local admin and sysadmin role. The reason for local admin is launching various executables on the local machine (Commvault) when starting the backup as well as various instance discovery functions that are performed (services query, etc)

sysadmin role is required as per MSFT for backup API

https://support.microsoft.com/en-us/topic/sql-server-vdi-backup-and-restore-operations-require-sysadmin-privileges-4797c4bc-ed60-8f1b-7978-8ee1cc701eab

Reply