Blog
Projects
About
Backtrack:
Blog
›
Required minimal permissions t…
Comments
Required minimal permissions to backup Microsoft SQL Server using Veeam
posted on December 9th 2020, at 10:27
by
lunarg
To backup Microsoft SQL Server, the account used for VM-side processing (application aware processing) requires certain permissions. Veeam recommends assigning the sysadmin role on the SQL Server but it is also possible to assign minimal permissions on the databases it needs to backup, which is the preferred method for security hardening.
The User Guide for VMware vSphere outlines the required permissions as well but for convenience, I've listed them here as well.
Instance-level roles:
Assign these roles:public
dbcreator
Database-level roles:
Assign these roles:
System databases master and model:db_backupoperator
db_datareader
public
System database msdb:db_backupoperator
db_dat
...
read more
add a comment
Tags
computer
windows
software
vmware
microsoft
exchange
linux
hardware
network
news
mac
home
powershell
office365
msoffice
server
sqlserver
ad
dell
soaring
internet
esx
sbs
rds
events
mssql
terminalserver
powercli
antivirus
hp
Archive
«
‹
April 2024
›
»
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Links
-
@harkx
-
Cats & Dogs
-
Jargon-free Security Guide
Quote
«
Most people tend to avoid true conflict. Ironically this breeds more conflict.
»
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs