Hi,

We frequently face "Revalidate TLS Certificate Error" whenever our source SQL Server restarts and a new certificate is issued. We want to have an option to auto-trust a changed certificate when Fivetran tries to sync the job after a certificate change. 

By default, if no certificate is manually installed, SQL Server issues a fresh self-signed cert every time the service starts. When this occurs, Fivetran SQL Server connections detect a new certificate and asks us to re-validate it. We have nearly 1000+ SQL Server connections and automated configuration and management of these connections via Terraform. Going into the dashboard to rerun the setup test is not viable. Also we do not otherwise use the REST API and adding scripts to manage this via the API adds complexity and overhead to the management of these connections. Instead of requiring us to manually revalidate each certificate in the UI or build and schedule a custom REST API script to fix them, we would like to have Fivetran resolve this automatically during its standard sync retry process. E.g. can there be an option to configure default permissions for TLS certificates which would allow Fivetran to automatically accept and revalidate the new certificate whenever a sync failure triggers a retry, ensuring that connections are restored without requiring manual intervention.

Many thanks,

Ajit