11-09-2012 07:15 PM
Hi all and good day,
I have an issue here with Netbackup and appreciate if anyone can help me out here.
We want to delegate backup and restoration to users that falls under the Backup Operators group. Our server is a Windows 2008 Enterprise and installed with Veritas NetBackup.
For now, we have created a local user (bckopr01) in the server and he is a member of the Backup Operators and Remote Desktop group. Additionally, we have created a login to Microsoft SQL Server 2008 for bckopr01 using Windows Authentication and assign with sysadmin roles. We have verified both OS and SQL login and both are fine.
When I run the Veritas NetBackup MS SQL Client as bckopr01 and fill in all relevant information, I got an error saying that "Application connection failed for <server name>/."
However, when I run the Veritas NetBackup MS SQL Client as Administrator and enter in bckopr01 SQL username and password into Userid and Password for SQL Standard or Mixed Security section, it works fine.
Is there anyway I can allow Backup Operator to be able to connect?
Additional troubleshooting information
Appreciate your help on this. Thank you in advance.
11-10-2012 08:19 AM
Anyone?
11-11-2012 04:18 AM
What's challange in assigning it to Local Admin group?
We do not want Domain Admin, But local admin is must
11-11-2012 06:59 AM
Well, thing is we have to adhere to the Information Security Policy and that Backup Operators should remain as Backup Operators without administrator rights.
So, is it safe to say that users under Backup Operator group will not be able to execute the NetBackup MS SQL Client?
Thanks!
11-12-2012 01:21 AM
Not sure to mention it accurately, though it is mentioned in guides as well account must be with administrative priviledged account which inherently enforces rights to access objects throughout all security layers within OS to Application.
It would not be good to choose any user which can perform backup (non administrator) and if it happens , then i guess it would be security breaches
Hope it helps
12-08-2012 02:47 AM
For SQL backups , Backup operators must have Admin privileages in that server or else should have full Access to SQL server management studio console.
Regards,
Sathish