I need to make a change to our security setup for our backup product (SQL Backup Pro). At present I have manually granted it access to the Backup LUNS on each of the DB servers however I am finding that when I want to run a restore, the account does not have the appropriate rights. (I have a work around in that I can run the restore under my own domain account but I want to resolve this issue so that it is not only myself that could complete restores)
Full Control from the top level of the data drive for each of the DB servers in our both the environments (so the rights cascade to ALL LUNS associated with that drive )
Note :- All our LUNS were mapped as mount points under one DRIVE.
Protocol:- iSCSI
Please help me to solve the above issue.
Thanks,
Nayab