HVA Error: F_JD0A57 Cannot Decrypt Database Encryption Key

Issue

Syncs fail. The following error appears:

F_JR0A11: Cannot decrypt database encryption key. The required certificate with thumbprint <thumbprint> is not known

Environment

Connector: HVA SQL Server

Resolution

To resolve this issue, first check whether your database is encrypted using SQL Server transparent data encryption (TDE). If so, do the following:

1. In Fivetran, go to your HVA SQL Server connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. Set the Using Transparent Data Encryption (TDE) toggle to ON.
5. Ensure the information provided in the setup form's TDE fields is complete and correct.
6. Click Save & Test.

If your database is not encrypted using TDE, contact our support team.

Cause

This issue occurs when we're unable to decrypt the SQL Server database encryption key, protected by TDE, because the required certificate with the specified thumbprint is not accessible or recognized. This may happen if the TDE settings in your connection's setup form are disabled, incomplete, or incorrect.