Skip to main content
Solved

Veeam SQL Agent Access Denied Error

S
  • Steve B
  • Not a newbie anymore
  • 1 comment

Iā€™m trying to set up the Veeam SQL Agent and have it up and running on my SQL server, but when I try to backup a DB I get the following error:

[ERROR]  Failed to backup database model. Error:  Error code: 0x80070005 Access denied. You must be logged in as a Windows administrator to create a virtual device. Failed to start VDI backup.

Iā€™m logged in as a domain administrator on the SQL server and am running the backup using a domain admin credential as well.  So Iā€™m not sure why this is failing.

Best answer by Steve B

Thanks all - how I got this to work (I was already a member of the local admins group on the SQL server) was to run the Backup SQL Veeam app as an administrator (right click - run as administrator).  Then everything worked great! :) 

View original
Chris.Childerhose
Shaokat
dloseke
6 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • Shaokat
    Shaokat
  • dloseke
    dloseke
  • CarySun
    CarySun
  • NZ_BenThomas
    NZ_BenThomas
  • leduardoserrano
    leduardoserrano
Did this topic help you find an answer to your question?

9 comments

Chris.Childerhose
Forum|alt.badge.img+21
  • Chris.Childerhose
  • Veeam Legend, Veeam Vanguard
  • 8402 comments
  • December 19, 2023

I would check the logs to see what might be causing the backup failure - C:\ProgramData\Veeam\Backup

Hard to say exactly what is causing that based on the credentials you are using.

Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site ā€“ https://just-virtualization.tech
Link State
1 person likes this
  • Link State
    Link State
coolsport00
Forum|alt.badge.img+20
  • coolsport00
  • Veeam Legend
  • 4109 comments
  • December 19, 2023

Do any of those accounts have access to any of the DBs youā€™re backing up though? Have you tried SA accounts?

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00
Chris.Childerhose
1 person likes this
  • Chris.Childerhose
    Chris.Childerhose
dips
Forum|alt.badge.img+7
  • dips
  • Veeam Legend
  • 808 comments
  • December 19, 2023

As @coolsport00 said, the account must have access to the Database to be able to back it up. Usually, permissions have to be delegated to the account being used to backup the SQL Server through SQL Server Management Studio

Dipen N. K. | IT Security Specialist | Veeam Legend 2022 - 2025 | Cyber Security Space VUG Leader
Chris.Childerhose
Link State
Iams3le
3 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • Link State
    Link State
  • Iams3le
    Iams3le
K
Forum|alt.badge.img
  • keironbell
  • Not a newbie anymore
  • 3 comments
  • December 19, 2023

You cold set the account with sysadmin rights within SSMS as mentioned by @dips or if you want more granular permissions, see below from the help center:

Application

Required Permission

Microsoft SQL Server

To back up Microsoft SQL Server data, the user whose account you plan to use must be:

  • Local Administrator on the target VM.
  • System administrator (has the Sysadmin role) on the target Microsoft SQL Server.

If you need to provide minimal permissions, the account must be assigned the following roles and permissions:

  • SQL Server instance-level role: public and dbcreator.
  • Database-level roles and roles for the model system database: db_backupoperator, db_denydatareader, public;
    for the master system database ā€” db_backupoperator, db_datareader, public;
    for the msdb system database ā€” db_backupoperator, db_datareader, public, db_datawriter.
  • Securables: view any definition, view server state, connect SQL.
Chris.Childerhose
Link State
2 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • Link State
    Link State
Link State
Forum|alt.badge.img+11
  • Link State
  • Veeam Legend
  • 602 comments
  • December 19, 2023

Hi @Steve B  to perform SQL backup aware, as already written, the user must be part of either the Local Administrator where the MS SQL Database resides and automatically has administrator privileges built in to SQL.
Or create\specify a dedicated user with the grants reported by @keironbell 

regards

Veeam: VMCA | VMCE | VMXP | Veeam Legend - Microsoft: MCITP | MCP | MCSA | 2008 R2 | 2012R2 | 2016 | MCSE Core Infrastructure | MCSE Cloud Platform - Azure: AZ900 | AZ104| AZ500 - AWS Cloud Practitioner - VMWare: VCP-DCV Vsphere 7.x - Cisco: CCNA (Expired)
Chris.Childerhose
Link State
Iams3le
3 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • Link State
    Link State
  • Iams3le
    Iams3le
S
  • Steve B
  • Author
  • Not a newbie anymore
  • 1 comment
  • Answer
  • December 20, 2023

Thanks all - how I got this to work (I was already a member of the local admins group on the SQL server) was to run the Backup SQL Veeam app as an administrator (right click - run as administrator).  Then everything worked great! :) 

Chris.Childerhose
coolsport00
Link State
5 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • coolsport00
    coolsport00
  • Link State
    Link State
  • vChris
    vChris
  • K
    keironbell
coolsport00
Forum|alt.badge.img+20
  • coolsport00
  • Veeam Legend
  • 4109 comments
  • December 20, 2023

Awesome. Thank you for sharing what worked for you šŸ‘šŸ»

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00
Chris.Childerhose
Link State
2 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • Link State
    Link State
Chris.Childerhose
Forum|alt.badge.img+21
  • Chris.Childerhose
  • Veeam Legend, Veeam Vanguard
  • 8402 comments
  • December 20, 2023

Great to hear you were able to get it working Steve.

Chris Childerhose - VMCA2024 | VMCE2023 | VMCE-SP2024 | Veeam Vanguard 8* | Veeam Legend 5* | vExpert 6* | VCAP-DCV/VCP-DCV | Object First Ace | Cisco Champion | Twitter: @cchilderhose | Blog Site ā€“ https://just-virtualization.tech
Link State
1 person likes this
  • Link State
    Link State
F
  • falconDD
  • New Here
  • 1 comment
  • October 8, 2024

In my case, double clicking the Veeam plugin utility loads wizard with local instance name in list and all DBs but after bacup configs it failed with same windows admin error. 

while The veeam.admin user has local admin privileges. However, when I run the Backup DB utility using "Run as Administrator," there is no password prompt. After a few seconds of exploring, it automatically selects non-local instances  in the wizard, and no databases are displayed.

Chris.Childerhose
Link State
2 people like this
  • Chris.Childerhose
    Chris.Childerhose
  • Link State
    Link State

Comment


Terms & Conditions