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

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.

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.

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.