SFTP ERROR - Invalid password or bad data (using Private Key)

Problem

Sometimes if you use SFTP Connection along with SSIS Secure FTP Task or ZappySys SFTP Driver like this one then you may receive below error.

Invalid password or bad data

Possible Cause

You may be using Private Key along with User ID and Password and ZappySys SFTP Connection is unable to load Private Key (May be key file is bad or password is invalid)

Possible Solution

1. First Make sure your PassPhrase is correct
2. Also try to use some Client tools like FileZilla / WinSCP see they can connect to remote FTP site using same settings you used with ZappySys SFTP connection
3. If same settings worked with FileZilla then you can try to use alternate Private Key file format using below steps see it helps. If settings fail in FileZilla too means its not ZappySys issue, something is wrong with file format or password.

Convert Private Key to OpenSSH format

1. Download Puttygen Utility from below link (Extract exe to some folder and double click to run) 
   https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
2. Click on Load button and locate your Private Key file (e.g. *.ppk file). It may prompt you for PassPhrase.
    
   
   
   
3. Once file is loaded you will see some information about private key data.
4. Now go to top menu Conversion > Export OpenSSH Key 
5. If prompted enter same PassPhrase save converted key.
6. Now go to SFTP Connection and test again see it works.

You setting might look like below

More Settings for Legacy Server (Optional)

In some cases you might get below error in that case few more settings needs to be changed to support legacy SFTP servers

https://zappysys.zendesk.com/hc/en-us/articles/360019215233-SFTP-Zappysys-Error-message-Test-Failed-Negotiation-Failed-Disconnected-by-the-server-Key-Exchange-failed-