NetWorker: SQL VDI Client Wizard does not expand the databases with SQL 2022

Summary: The NetWorker New Client Wizard fails to create a SQL Server client resource for the NetWorker Module for Microsoft (NMM) version 19.9. As a result the Client Wizard does not expand databases for Microsoft SQL Server 2022. The error reported is: Encryption is not supported on the client. ...

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

The NetWorker New Client Wizard fails to create a SQL Server client resource for the NetWorker Module for Microsoft (NMM) version 19.9. As a result the Client Wizard does not expand databases for Microsoft SQL Server 2022. 
The following symptoms are observed: 

  • The New Client Wizard reports this error
nsrsqlsv: Encryption is not supported on the client
  • The same error is observed on a backup of a manually configured client resource. 
  • The following error is also observed when running the command
nsrnmmsv -P
nsrnmmsv: Encryption not supported on the client.

Cause

After investigation, the following specific conditions led to the problem:

  • Starting with Windows Server 2022 Standard, the default API library for client applications to connect to SQL Server is OLEDB32, Microsoft OLE DB Driver for SQL Server.
  • With SQL Server versions before 2022, the default API library for client applications to connect to SQL Server is SQLNCLI11, Microsoft SQL Server 2012 Native Client.
  • SQL Server 2022 installation does not install by default the Microsoft SQL Server 2012 Native Client.
  • SQL Server 2022 installation installs by default the Microsoft OLE DB Driver for SQL Server.
  • In this case, a third-party application that depends on the older library, Microsoft SQL Server 2012 Native Client, to connect to SQL.
  • This third-party application installed Microsoft SQL Server 2012 Native Client as part of the package

NMM detects Microsoft SQL Server 2012 Native Client and automatically use this instead of the latest library, Microsoft OLE DB Driver for SQL Server.

Resolution

To resolve this issue, upgrade NetWorker Client and NetWorker Module for Microsoft to one of the following releases of NetWorker:   

  • 19.9.0.7
  • 19.10.0.3
  • 19.11 

However, as a temporary workaround, you can try the following steps:

Workaround:
1. Ensure that the Microsoft SQL Server 2012 Native Client is not installed on the system. If it is installed, uninstall it.
 
Verification:
To verify that the issue has been resolved, check that the SQL VDI backup logs for the error message "nsrsqlsv: Encryption is not supported on the client" or "nsrnmmsv: Encryption not supported on the client." If the error message is no longer present, the issue has been resolved.
 

NOTE: If you are unsure about the workaround or if the issue persists after implementing the workaround, upgrade to one of the fixed NetWorker releases defined.
Article Properties
Article Number: 000223613
Article Type: Solution
Last Modified: 07 Feb 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.