Hello,
We are currently investigating whether Commvault SQL Server Agent supports connecting to Microsoft SQL Server using TLS with TDS 8.0 and Strict Encryption.
Our environment is configured according to Microsoft's guidance for SQL Server strict encryption:
- SQL Server is configured with a valid trusted certificate.
- TDS 8.0 is enabled.
- Strict Encryption is enabled.
- Connections using SQL Server Management Studio (SSMS) work successfully.
- Connections using PowerShell also work successfully.
Reference: Connect to SQL Server with strict encryption
What we would like to know is:
- Does Commvault SQL Server Agent support connections using TDS 8.0?
- Does Commvault support Strict Encryption in the same way as SSMS and modern Microsoft SQL drivers?
- Which SQL client/driver version is used by Commvault when connecting to protected SQL Server instances?
- Is there any Commvault-specific configuration required to enable encrypted SQL Agent connections?
- Has anyone successfully protected SQL Servers that are configured for TDS 8.0 + Strict Encryption only?
We can successfully connect using Microsoft tools, but we would like to verify whether Commvault can establish the same encrypted connection before enabling this configuration in production.
Any information or experience would be greatly appreciated.
Thank you.
