Error: SSH_MSG_DISCONNECT: 2 Too Many Authentication Failures

Issue

While connecting a database to Fivetran using an SSH tunnel, the following error appears:

SSH_MSG_DISCONNECT: 2 Too many authentication failures

Environment

Database connectors using the SSH tunnel connection method.

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your connector page.
2. Select the Setup.
3. Under Connection Details, locate and copy the Public Key.
4. Add the public key to your SSH server's authorized_keys file.

For more information on adding the public key to your SSH server's authorized_keys file, see step 9 of our create SSH user documentation.

NOTE: If Fivetran provides your SSH tunnel, contact our support team.

Cause

This issue occurs when you don't add the public SSH key from the database setup page to your SSH server's authorized_keys file.