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. Go to the Setup tab of your connector details page.
2. Under Connection Details, locate and copy the Public Key.
3. Add the public key to your SSH server's authorized_keys file.

NOTE: 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.

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.