07-06-2016 09:44 PM
We have a SQL 2012 environment set up with AlwaysON HA Availability Groups and are currently transferring the backups over to NetBackup. Our SQL 2008 environment has already been configured and is working.
The difference with the SQL 2012 servers is that the backup client does not connect to the SQL instance locally unless you run the client "As Administrator". I have configured the backup policy and scripts but the backup job when launched from the NetBackup policy fails with the error "Error: Failed to query database metadata for <xxxxx>".
If I launch the backup client (which must be run "as administrator") and kick off the backup script from there the backup job completes successfully.
So I'm pretty sure the problem is because the job needs to run as administrator which it doesn't do when launched from NetBackup.
The Netbackup services have been configured to use the backup service account which has full access to SQL and is a domain admin, and UAC is also disabled.
Is there a way to make NetBackup execute the job "as administrator" or do I need to set things up differently?
07-07-2016 07:05 AM
Hi
Account which you are using for backups, get it following permissions:
1) add it to bulit in administrator group of windows 2012.
2) Provide it SYSADMIN privilages in MSSQL.
Run Netbackup CLient & netbackup legacy network service with this user.
Restart your netbackup services and then test your backup.
It should work. :)
07-07-2016 12:50 PM
The account already has sysadmin role and is a member of domain admins which is in the local administrator group by default.
I have just tried adding it directly to make sure but it did not make any difference. The same issue still exists.
07-07-2016 06:01 PM
I second this part:
*****************************************
Run Netbackup CLient & netbackup legacy network service with this user.
******************************************
I've actually had to change all the NetBackup services on a client to use a specific account to get it to work...
Hopefully NetBackup 8.whatever will force this change since generic System Accounts have been defined as "evil"...
07-07-2016 07:00 PM
07-12-2016 02:59 PM
Thanks Marianne, I have enabled the logging and completed a successful and failed job but the logs don't really tell me much more than what I was already seeing in the activity log in netbackup.
Ultimately, all it tells me is that it is unable to connect to the database.
The logs are attached. Maybe you can find something useful.
07-12-2016 10:59 PM
07-13-2016 01:02 PM
They already are...
And they've definitely been restarted since they were changed too.
07-14-2016 10:25 AM
other nodes?