NetWorker: NMM SQL backup failure after upgrade to 19.11 or later - No Active SQL Server found.

Summary: NetWorker Module for Microsoft (NMM) SQL Server backup fails with "No Active SQL Server Found." This issue appears after upgrading an NMM client from 19.10.x to 19.11.x (or later).

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

NetWorker Module for Microsoft (NMM) backups fail for SQL server. The following error appears:

98188: nsrsqlsv: No Active SQL Server found.
98921: nsrsqlsv: Failed to get preferred node for backup of Availability group (xxxxxxxxxxx) with error: [bsGetPreferredNodeOnCurrentNode]: Availability Group (xxxxxxxxxxx) not found on node..
38008: nsrsqlsv: SSL Provider: The certificate chain was issued by an authority that is not trusted.
This issue appears on NMM clients after 19.11.x. It can appear after upgrading from 19.10.x (or prior), or during fresh setup of an NMM client on 19.11.x (or later).

Cause

NetWorker 19.11.x introduced code changes regarding how reverse Domain Name System (DNS) handling is performed. 

Resolution

Steps taken to fix the issue:

  1. Added host file entries (IP, Fully Qualified Domain Name (FQDN), Short name) on the backup server's hosts file for Cluster instance, each node, backup server, and Data Domain.
  2. Added host file entries (IP, FQDN, Short name) on both nodes hosts file for Cluster instance, each node, backup server and Data Domain.
  3. If OLE database drivers installed are version 18.x o19.x, Enable Flag 2 by setting to 1. For example:
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSSQLServer\Client\SNI19.0\GeneralFlags\Flag2 (set to 1)
  1. Perform upgrade.
  2. Clear peer information from backup server and SQL nodes. For instructions, see: NetWorker: Fixing inconsistent NSR peer information
  3. Run backup. Backups were then successful.

Affected Products

NetWorker Module

Products

NetWorker Family, NetWorker, NetWorker Module for Microsoft
Article Properties
Article Number: 000429113
Article Type: Solution
Last Modified: 05 Mar 2026
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.