NVP vProxy: SQL Server 2022 VM Backups Fail “Unable to log in to SQL instance. Error 1359”
Summary: The NetWorker VMware Protection (NVP) vProxy appliance is configured to back up a SQL Server 2022 Virtual Machine (VM) using MSVMAPPAGENT. The backup fails with "'Unable to log in to SQL Server instance. Error Code = 1359.'" ...
Symptoms
- SQL Server 2022 app consistent backups (
MSVMAPPAGENT) are configured using the NetWorker VMware Protection (NVP) vProxy appliance. - The VM backup fails with the following error logged in the VM backup session log:
YYYY-MM-DDTHH:mm:SSZ INFO: [@(#) Build number: 15] MSSQL: NetWorker VM agent for Microsoft Applications version 19.4.0.0 is present on VM VM_NAME (vm-45) YYYY-MM-DDTHH:mm:SSZ ERROR: [@(#) Build number: 15] MSSQL: MSSQL:validate_application: NetWorker VM agent for Microsoft Applications: Unable to execute discovery command, error: 'Unable to log in to SQL Server instance 'INSTANCE_NAME'. Error Code = 1359.' YYYY-MM-DDTHH:mm:SSZ INFO: [@(#) Build number: 15] MSSQL: MSSQL:validate_application: NetWorker VM agent for Microsoft Applications command error: exit status 120 YYYY-MM-DDTHH:mm:SSZ INFO: [@(#) Build number: 15] MSSQL: MSSQL:validate_application: NetWorker VM agent for Microsoft Applications: Unable to execute discovery command, error: 'Unable to log in to SQL Server instance 'INSTANCE_NAME'. Error Code = 1359.' YYYY-MM-DDTHH:mm:SSZ INFO: [@(#) Build number: 15] "Text": "Backup has FAILED. Backup of the application \"MSSQL\" on the virtual machine \"INSTANCE_NAME\" has failed. Unable to perform MSSQL Agent operation 'validate_application' on VM VM_NAME (vm-45): NetWorker VM agent for Microsoft Applications: Unable to execute discovery command, error: 'Unable to log in to SQL Server instance 'INSTANCE_NAME'. Error Code = 1359.'\n",
Cause
The NetWorker VMware Protection (NVP) vProxy solution does not support SQL (MSVMAPPAGENT) backups of SQL server 2022.
Resolution
See the NetWorker Compatibility Matrix for your NetWorker version on E-LAB (log in is required)
The NETWORKER and ALL COMPONENTS, REPORTS, MODULES guides contain a table for NetWorker Module for Microsoft - SQL Server. This table includes the support information for both NMM and NVP vProxy (MSVMAPPAGENT) support. The table includes the following footnote:
58266: NVP App Consistent for SQL Server is not supported for SQL Server 2022 and Windows 2022.
Contact your Dell account or sales representative regarding a Request for Enhancement (RFE).
Workaround:
Install the NetWorker client and NetWorker Module for Microsoft (NMM) packages on the SQL Server 2022 machine. SQL backups can be obtained using the NMM client software.
NMM packages and documentation are available through Dell Support NetWorker Module for Microsoft downloads.