Error: Change in TLS Certificate Detected - Revalidate

Issue

The following warning message frequently appears:

Change in TLS Certificate Detected - Revalidate

Environment

Database connectors using TLS certificate verification.

Resolution

Consult your database administrator to confirm what type of certificates you are using. We recommend using self-signed certificates as these have a lifetime of five years.

Cause

If the certificates are changing frequently, it may be because you are using database-generated certificates. Database-generated certificates reset upon reboot of the database.

NOTE (SQL Server only): If you have not installed your own certificate, SQL Server will generate one each time it is started. Learn more in Microsoft's SQL Server-generated self-signed certificates documentation. Therefore, the signature that Fivetran stores will not match after a database restart. You must generate your own certificate with a utility like OpenSSL and install it to SQL Server.