cancel
Showing results for 
Search instead for 
Did you mean: 

VMware + SQL

NBU_10
Level 2

Hi,

 

I am trying to take backup of SQL database in a virtual machine using VMware policy type. Following things were done, but i am getting error "SQL Server Native Client 11.0][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database".

Installed NBU client s/w in the Virtual machine.

Changed logon account from local admin to an account which has DB admin rights for client services.

Normal snapshot and VM backup completed without any issues. But SQL backup is getting failed for all database with the above error. Can you please let me know what is the issue here and what needs to be done to fix it.

Note: Client OS is windows 2012.

 

3 REPLIES 3

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

either

- give NT AUTHORITY\SYSTEM sysadmin role in SQL Server instance

or

- prepare an AD account, assign him sysadmin role in SQL Server instance, and make it Startup Account of NetBackup Services (Client and Legacy)

 

Regards

Michal

NBU_10
Level 2

Hi Michal,

 

As i mentioned in my previous post, both the service logon account has been changed to an account which has DB admin rights...

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

OK it was not clear to me which services you mean (if NBU or SQL).

Go through NetBackup Admin Guide for MS SQL, pages 97-98, and doublecheck account settings.

Michal