Error: Unable to Validate Certificate Error

Issue

While setting up a connection, the following error appears:

Unable to validate certificate

Environment

All SQL Server connectors

Resolution

To resolve this issue, do the following:

1. Ensure the User and Password you've provided are correct and properly formatted.

2. Verify that the authorizing user can access the relevant database and has the permission required to set up the connection in Fivetran. For more information, see the Prerequisites section of the relevant connector's setup guide.

3. Check for recent changes to the TLS certificate in the source. If changes have occurred:

   i. In Fivetran, click Account Settings > General.

   ii. Scroll down to Validated Certificates & Keys.

   iii. Locate the applicable certificate.

   iv. On the right-hand side, click X to remove.

   v. Go to your SQL Server connection page.

   vi. Select the Setup tab.

   vii. Click Test connection to validate the new certificate.

   You need to have the Account Administrator role to manage certificates.

Cause

This issue occurs when we're unable to validate the TLS certificate associated with your connection, the user credentials are incorrect or improperly formatted, or the user lacks the necessary database permissions.