NVP vProxy: SQL Server 2022 VM backups fail with "'Unable to log in to SQL Server instance. Error Code 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) have been 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: https://elabnavigator.dell.com/eln/modernHomeAutomatedTiles?page=NetWorker
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.
Request For Enhancement (RFE) NW-I-2427 was submitted requesting MSVMAPPAGENT support for Windows Server 2022 and SQL server 2022. Contact your Dell Site Account or Sales Team to track this RFE.
Workaround:
Install the NetWorker client and NetWorker Module for Microsoft (NMM) packages on the SQL Server 2022 machine. Both packages should be a minimum of 19.7.0.x. SQL backups can be obtained using the NMM client software.
NMM packages and documentation are available through: https://www.dell.com/support/home/product-support/product/networker-module-for-microsoft/drivers