In Enterprise Vault (EV) version 15.1 and later, the deployment scanner fails to connect to the SQL server.

Problem

In Enterprise Vault (EV) version 15.1 and later, the deployment scanner fails to connect to the SQL server.

Error Message

In the DTrace logs, the following error message is observed:

45 18:31:34.599 [11424] (Deployment_Scanner) <7312> EV:H {DecodeAndLogError:#931} Error Description: [SSL Provider: The certificate chain was issued by an authority that is not trusted.]

Cause

In Enterprise Vault 15.1,  the product uses the Microsoft OLE DB Driver 19 for SQL connections. This driver enforces encryption validation by default. As a result, if the SQL Server certificate is not trusted or improperly configured, the connection attempt will fail during certificate validation.

Solution

Ensure that a valid SSL certificate is associated with the SQL Server instance. If no valid certificate is configured, you can disable the “Force Encryption” option in SQL Configuration Manager.

To disable Force Encryption:

1. Open SQL Server Configuration Manager on the SQL Server.
2. Expand SQL Server Network Configuration.
3. Right-click on Protocols for <SQLInstanceName> and select properties.
4. Navigate to the Flags tab.
5. Set Force Encryption to No.
6. Click Apply and OK.
7. Restart the SQL Server service for the changes to take effect.

Refer article: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19