Avamar：SQL 备份失败，并显示“BACKUP DATABASE permission denied in database”错误

Summary: 本知识库 （KB） 文章讨论 Avamar SQL 备份由于权限问题而失败。

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

由于日志中显示以下错误消息，SQL 客户端备份可能会失败：
 

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BACKUP DATABASE permission denied in database 'OperationsManager'.
 (Log #10)
avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting and the timeout interval had elapsed' (Log #10)
avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting and the timeout interval had elapsed' (Log #10)
avsql Error <6479>: Timed out. Was Microsoft SQLServer running? (Log #10)
avsql Error <6479>: Timed out. Was Microsoft SQLServer running? (Log #10)
avtar Info <7202>: Backup CANCELLED, wrapping-up session with Server (Log #2)
avtar Info <7202>: Backup CANCELLED, wrapping-up session with Server (Log #3)
...
avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BACKUP DATABASE permission denied in database 'master'.
avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BACKUP DATABASE permission denied in database 'msdb'.
...
avsql Error <14272>: There are no successfully finished database tasks! 
avsql Error <14294>: An error occurred when generating sql metadata

Cause

为备份代理服务配置的帐户（默认为本地 SYSTEM）没有备份 SQL Server 数据库的相应权限。

Resolution

打开 SQL Server Management Studio 并验证备份代理服务帐户是否已添加到 SQL SERVER 角色“sysadmin”。
 
要将 SQL Server 角色分配给备份代理服务帐户，请执行以下作：
  1. 在 SQL 客户端上，启动 SQL Server Management Studio。
  2. 在 SQL Server Management Studio 窗口的左窗格中，展开树以首先显示所需的 SQL Server，然后显示 “Security ”文件夹。
  3. 在 Security 文件夹下，单击 Logins 以在右侧窗格中显示用户。
  4. 在“ 登录名 ”列表中，右键单击 帐户 （NT Authority\SYSTEM 或专用备份帐户），然后单击 “属性”。
  5. 在登录属性框中，选择 服务器角色 页面。
  6. 在 服务器 角色框中，通过单击系统管理员角色旁边的复选标记来启用该角色。
  7. 单击 OK 保存更改。

Affected Products

Avamar, Avamar Plug-in for SQL

Products

Avamar
Article Properties
Article Number: 000039635
Article Type: Solution
Last Modified: 22 Jul 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.