Veeam SQL Explorer

Availability for the Always-On Enterprise

Veeam SQL Explorer

Veeam Logoby spf62 » Wed 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
spf62
Enthusiast
 
Posts: 57
Liked: never
Joined: Fri Sep 17, 2010 12:33 pm
Location: Connecticut
Full Name: Steve Fritsch

Re: Veeam SQL Explorer

Veeam Logoby DGrinev » Wed 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!
DGrinev
Veeam Software
 
Posts: 178
Liked: 17 times
Joined: Thu Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev

Re: Veeam SQL Explorer

Veeam Logoby spf62 » Wed 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
spf62
Enthusiast
 
Posts: 57
Liked: never
Joined: Fri Sep 17, 2010 12:33 pm
Location: Connecticut
Full Name: Steve Fritsch

Re: Veeam SQL Explorer

Veeam Logoby jmmarton » Wed 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/backup/em/veeam_backup_em_roles.html?ver=95

Joe
jmmarton
Veeam Software
 
Posts: 676
Liked: 77 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: Veeam SQL Explorer

Veeam Logoby spf62 » Wed Apr 19, 2017 6:44 pm

Joe, do you know if I can choose specific SQL servers or is it a blanket permission?
spf62
Enthusiast
 
Posts: 57
Liked: never
Joined: Fri Sep 17, 2010 12:33 pm
Location: Connecticut
Full Name: Steve Fritsch

Re: Veeam SQL Explorer

Veeam Logoby jmmarton » Wed 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
jmmarton
Veeam Software
 
Posts: 676
Liked: 77 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: Veeam SQL Explorer

Veeam Logoby spf62 » Thu Apr 20, 2017 11:39 am

thats some good info, thanks Joe!! much appreciated
spf62
Enthusiast
 
Posts: 57
Liked: never
Joined: Fri Sep 17, 2010 12:33 pm
Location: Connecticut
Full Name: Steve Fritsch


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Google Feedfetcher and 66 guests