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:
nsrsqlsv: Encryption is not supported on the client
nsrnmmsv -P nsrnmmsv: Encryption not supported on the client.
After investigation, the following specific conditions led to the problem:
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:
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.