11-27-2013 02:37 AM
i was reading this
Article:TECH31961 | | | Created: 2004-01-05 | | | Updated: 2013-10-23 | | |
Article URL http://www.symantec.com/docs/TECH31961
|
and this error most commonly occured
My question
1.is it necessary to give netbackup Client service as admin rights on SQL Agent?
2.If Yes,Do we have to give same user id and password as we give in NetBackup MS SQL GUI and SQL Server ,
(for eg. sa password ......... )
3.Do SQL backups from Netbackup will run on Local Account of Netbackup Client Service?
Solved! Go to Solution.
11-27-2013 02:50 AM
It all depends on SQL rights on a database.
See About SQL Server privileges and About setting the SQL Server logon for scheduled operations in NBU for SQL Admin guide: http://www.symantec.com/docs/DOC5173
11-27-2013 02:51 AM
With later SQL versions you need to set both the NetBackup Client Service account and the NetBackup Legacy Network Service account to run as a user that has full SQL admin rights for it to work
Hope this helps
11-27-2013 02:50 AM
It all depends on SQL rights on a database.
See About SQL Server privileges and About setting the SQL Server logon for scheduled operations in NBU for SQL Admin guide: http://www.symantec.com/docs/DOC5173
11-27-2013 02:51 AM
With later SQL versions you need to set both the NetBackup Client Service account and the NetBackup Legacy Network Service account to run as a user that has full SQL admin rights for it to work
Hope this helps
11-27-2013 03:00 AM
Thanks both, i have all my answers
11-27-2013 03:22 AM
That is all great - but i have found when you come to actually do it that the legacy network services also needs to use that account - doesnt seem to get mentioned anywhere in the docs! - seems to be either a windows 2008 or SQL 2008 requirement (cant remember which now)
11-27-2013 04:14 AM
ok thanks Marks Solution
i have Win 2003 R2 32 BIT Server
SQL 2008 R2 Agent
11-27-2013 04:38 AM
OK - well being SQL 2008 you may need to do it for that - if it fails without it then set the legacy network service too to see if it resolves it
11-27-2013 05:07 AM
well i will check and will tell u tomorrow
11-27-2013 08:49 AM
My whole idea behind referring you to the manual is that you should read it, show it to the SQL dba and then decide between the two of you if it is necessary to change NBU logon account and which account should be used.
My recommendation has always been to use the same service account as for SQL services.