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 » Apr 19, 2017 1:30 pm

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
Veeam Software
Posts: 1747
Liked: 222 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: Veeam SQL Explorer

Post by DGrinev » Apr 19, 2017 5:33 pm

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 » Apr 19, 2017 5:38 pm

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: 1658
Liked: 224 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Veeam SQL Explorer

Post by jmmarton » Apr 19, 2017 6:09 pm

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 » Apr 19, 2017 6:44 pm

Joe, do you know if I can choose specific SQL servers or is it a blanket permission?

jmmarton
Veeam Software
Posts: 1658
Liked: 224 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: Veeam SQL Explorer

Post by jmmarton » Apr 19, 2017 9:20 pm

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 » Apr 20, 2017 11:39 am

thats some good info, thanks Joe!! much appreciated

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot], Google [Bot], veremin and 31 guests