Comprehensive data protection for all workloads
Post Reply
spf62
Enthusiast
Posts: 65
Liked: never
Joined: Sep 17, 2010 12:33 pm
Full Name: Steve Fritsch
Location: Connecticut
Contact:

Veeam SQL Explorer

Post by spf62 »

Hello all, just a few questions for those using Veeam SQL Explorer:

What domain user rights does one need for this?

What access does this give the user on Veeam B&R?

Can I limit what servers that person has access to?

any help is appreciated
thanks
DGrinev
Veteran
Posts: 1943
Liked: 247 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: Veeam SQL Explorer

Post by DGrinev »

Hi Steve,

Local administrator rights are needed to use Veeam SQL Explorer, so the user has full access to the Veeam B&R console.
What's the use case to limit server access?

Please, review required rights and permission in the User Guide. Thanks!
spf62
Enthusiast
Posts: 65
Liked: never
Joined: Sep 17, 2010 12:33 pm
Full Name: Steve Fritsch
Location: Connecticut
Contact:

Re: Veeam SQL Explorer

Post by spf62 »

The question to us Veeam SQL explorer came from our DBA team, but we have been reluctant to give them this until we found out the questions above. One thing we cannot do is give them full access to our B&R environment. That would violate our SOX control as they are not domain admins

thanks for your quick response
jmmarton
Veeam Software
Posts: 2097
Liked: 310 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Veeam SQL Explorer

Post by jmmarton »

Note that if you have Enterprise Plus edition, you can delegate SQL restores to your DBAs within Enterprise Manager rather than give them access to the VBR console.

https://helpcenter.veeam.com/docs/backu ... tml?ver=95

Joe
spf62
Enthusiast
Posts: 65
Liked: never
Joined: Sep 17, 2010 12:33 pm
Full Name: Steve Fritsch
Location: Connecticut
Contact:

Re: Veeam SQL Explorer

Post by spf62 »

Joe, do you know if I can choose specific SQL servers or is it a blanket permission?
jmmarton
Veeam Software
Posts: 2097
Liked: 310 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Veeam SQL Explorer

Post by jmmarton »

From the link I provided:

Users with the Portal User or Restore Operator role can access their restore scope — a list of VMs that can be recovered by appropriate personnel. For example, database administrators can restore database servers (SQL, Oracle, or other) — this is their restore scope;

Joe
spf62
Enthusiast
Posts: 65
Liked: never
Joined: Sep 17, 2010 12:33 pm
Full Name: Steve Fritsch
Location: Connecticut
Contact:

Re: Veeam SQL Explorer

Post by spf62 »

thats some good info, thanks Joe!! much appreciated
Post Reply

Who is online

Users browsing this forum: AdsBot [Google], Google [Bot], Kirassant, Majestic-12 [Bot] and 185 guests