topic Re: SFTP Connection without host public key in Connectivity & Data Prep

SFTP Connection without host public key

ManuelRühl — Fri, 14 Apr 2023 06:29:13 GMT

I tried to establish a connection via SFTP with username and password. The Server is online and I can access the folders via WinSCP.

But the Qlik-Connection needs a key even the fields are not marked as mandatory:

Re: SFTP Connection without host public key

ManuelRühl — Sat, 15 Apr 2023 06:47:58 GMT

In the documentation is written: "You must specify at least one of Password OR Private Key File."

The sftp-servers host told me: "It seems like wrong config for ftp client. I think this message say "You try to connect with rsa key but key not found". But we don't use this type of auth. Vendor should off auth by key and on auth by login and password."

Re: SFTP Connection without host public key

ManuelRühl — Fri, 28 Apr 2023 06:59:57 GMT

Answer from Qlik Support:

A host public key or host public key fingerprint is also required for authentication; it is not possible using just a user name and password.

Für die Authentifizierung ist ebenfalls ein Host Public Key oder Host Public Key fingerprint notwendig, nur über Username und Password ist es nicht möglich.

Re: SFTP Connection without host public key

giohb_ — Thu, 02 Nov 2023 19:29:17 GMT

Were you able to figure out how to get the Host Public Key fingerprint ?

I am getting that error:

Failed: The specified public key fingerprint does not match server fingerprint!

Re: SFTP Connection without host public key

Bjorn_Wedbratt — Sat, 04 Nov 2023 19:12:37 GMT

You could try using ssh-keyscan <address for your sftp server>:

ssh-keyscan example.com
# example.com:22 SSH-2.0-OpenSSH_5.3
example.com ssh-rsa AAAAB3NzaC1

If using WinScp the host key is cached and can be retrieved using details found here: https://winscp.net/eng/docs/faq_hostkey#:~:text=Once%20you%20connect%2C%20WinSCP%20caches,Server%20and%20Protocol%20Information%20Dialog.

Hope that helps.

Best regards

Björn

Re: SFTP Connection without host public key

Ken_T — Tue, 25 Feb 2025 18:25:06 GMT

did you ever find the solution for the error:

Failed: The specified public key fingerprint does not match server fingerprint!
?

Re: SFTP Connection without host public key

Frank_S — Tue, 25 Feb 2025 23:58:35 GMT

Check this article.

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-SFTP-data-connection-in-a-Qlik-Cloud/ta-p/2133069

Hope it helps.

Re: SFTP Connection without host public key

ManuelRühl — Fri, 10 Apr 2026 10:20:59 GMT

@Ken_T @giohb_

Sorry for late reply. 😉

Failed: The specified public key fingerprint does not match server fingerprint!

I had the problem today and the solution for me was to change the encryption algorithm from RSA to nistp384. I checked the algorithm via winscp. Establish a connection to the sftp via user and password.
On the bottom there is a golden lock -> Double Click and there are the correct information you need.