NVP-vProxy: SQL Server Backup login fails as it does not have the sysadmin role assigned

요약: SQL virtual machine (VM) backups performed with the NetWorker VMware Protection (NVP) vProxy appliance fail indicating "NT AUTHORITY\SYSTEM does not have the sysadmin role assigned."

이 문서는 다음에 적용됩니다. 이 문서는 다음에 적용되지 않습니다. 이 문서는 특정 제품과 관련이 없습니다. 모든 제품 버전이 이 문서에 나와 있는 것은 아닙니다.
기타 리소스 확인

증상

The NetWorker VMware Protection integration is configured with the vProxy Appliance. The Microsoft Virtual Machine Application Agent (MSVMAPPAGENT) for SQL Server application-consistent protection is being used to perform a backup of a VM with Microsoft SQL Server. The VM backup fails, indicating that the "NT AUTHORITY\SYSTEM" does not have the sysadmin role assigned.

The backup session log shows: 
YYYY-MM-DD HH:MM:SS ERROR:  [127] MSSQL: MSSQL:validate_application: NetWorker VM agent for Microsoft Applications: Unable to execute discovery command, error: 'The login 'NT AUTHORITY\SYSTEM' for SQL instance [VM_NAME] does not have the sysadmin role assigned.'

원인

The MSVMAPPAGENT runs under the "NT AUTHORITY\SYSTEM" account, and it does not have sufficient rights to perform data protection operations. 

해결

The MSVMAPPAGENT "Software and security requirements" section of the Dell NetWorker VMware Integration Guide indicates the sysadmin role must be granted to the "NT AUTHORITY\SYSTEM" account. Here is an overview of the steps to grant the permissions to the "NT AUTHORITY\SYSTEM" account.
 

  1. On the SQL VM, Open Microsoft SQL Server Management Studio.
  2. Connect to the SQL Server instance. 
NOTE: The steps must be performed against all SQL Server instances on the VM.
 
  1. In the Object Explorer tree view, expand "Security > Logins."
  2. Open the Properties for the "NT AUTHORITY\SYSTEM" account.
SQL Server Management Studio (SSMS) Security Logins 
Figure 1: SQL Server Management Studio (SSMS) Security Logins
  1. In the Login Properties windows, select "Server Roles" in the left pane.
  2. In the right pane, select "sysadmin."
  3. Select OK to close the Login Properties Window.  
SSMS NT AUTHORITY\SYSTEM login properties 
Figure 1: SSMS NT AUTHORITY\SYSTEM login properties
문서 속성
문서 번호: 000173347
문서 유형: Solution
마지막 수정 시간: 17 11월 2025
버전:  4
다른 Dell 사용자에게 질문에 대한 답변 찾기
지원 서비스
디바이스에 지원 서비스가 적용되는지 확인하십시오.