SFTP to host fails with error as type 11
When I try to connect to
mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com from SQL Server it fails and I am attaching log file below. I used the same version on my laptop and it works so that means the login details and password is correct. I tried FileZilla on the same SQL server and I am able to connect to the same host. Can you please help in solving this as I am struggling with this and don't want to manually upload 5 files 7 days a week?
. 2022-07-27 12:02:08.006 -------------------------------------------------------------------------- . 2022-07-27 12:02:08.022 WinSCP Version 5.21 (Build 12524 2022-06-15) (OS 6.3.9600 - Windows Server 2012 R2 Datacenter) . 2022-07-27 12:02:08.022 Configuration: nul . 2022-07-27 12:02:08.022 Log level: Normal . 2022-07-27 12:02:08.022 Local account: xxxxxxxx\xxxxxxxxxxxxxxxxxx . 2022-07-27 12:02:08.022 Working directory: B:\Apps\SKNManager\SL350_AppointmentsIn72Hrs\Files\BatchFile . 2022-07-27 12:02:08.022 Process ID: 7324 . 2022-07-27 12:02:08.022 Ancestor processes: ... . 2022-07-27 12:02:08.022 Command-line: "C:\Program Files (x86)\WinSCP\WinSCP.exe" /log="B:\Apps\SKNManager\SL350_AppointmentsIn72Hrs\Files\BatchFile\WinSCP.log" /ini=nul /script="B:\Apps\SKNManager\SL350_AppointmentsIn72Hrs\Files\BatchFile\AppointmentIn72Hrs_UploadFile.txt" . 2022-07-27 12:02:08.022 Time zone: Current: GMT+1, Standard: GMT+0 (GMT Standard Time), DST: GMT+1 (GMT Daylight Time), DST Start: 27/03/2022, DST End: 30/10/2022 . 2022-07-27 12:02:08.022 Login time: 27 July 2022 12:02:08 . 2022-07-27 12:02:08.022 -------------------------------------------------------------------------- . 2022-07-27 12:02:08.022 Script: Retrospectively logging previous script records: > 2022-07-27 12:02:08.022 Script: open sftp://10959795:***@mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com/ -hostkey="ssh-rsa 3072 bFCXgHdgCzL7mYTH8PZoSmYyiq0ryMDkYzk1Z2YfIeE" . 2022-07-27 12:02:08.022 -------------------------------------------------------------------------- . 2022-07-27 12:02:08.022 Session name: 10959795@mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com (Ad-Hoc site) . 2022-07-27 12:02:08.022 Host name: mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com (Port: 22) . 2022-07-27 12:02:08.022 User name: 10959795 (Password: Yes, Key file: No, Passphrase: No) . 2022-07-27 12:02:08.022 Tunnel: No . 2022-07-27 12:02:08.022 Transfer Protocol: SFTP . 2022-07-27 12:02:08.022 Ping type: Off, Ping interval: 30 sec; Timeout: 15 sec . 2022-07-27 12:02:08.022 Disable Nagle: No . 2022-07-27 12:02:08.022 Proxy: None . 2022-07-27 12:02:08.022 Send buffer: 262144 . 2022-07-27 12:02:08.022 Compression: No . 2022-07-27 12:02:08.022 Bypass authentication: No . 2022-07-27 12:02:08.022 Try agent: Yes; Agent forwarding: No; KI: Yes; GSSAPI: Yes . 2022-07-27 12:02:08.022 GSSAPI: KEX: No; Forwarding: No; Libs: gssapi32,sspi,custom; Custom: . 2022-07-27 12:02:08.022 Ciphers: aes,chacha20,blowfish,3des,WARN,arcfour,des; Ssh2DES: No . 2022-07-27 12:02:08.022 KEX: ecdh,dh-gex-sha1,dh-group14-sha1,rsa,WARN,dh-group1-sha1 . 2022-07-27 12:02:08.022 SSH Bugs: Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto,Auto . 2022-07-27 12:02:08.022 Simple channel: Yes . 2022-07-27 12:02:08.022 Return code variable: Autodetect; Lookup user groups: Auto . 2022-07-27 12:02:08.022 Shell: default . 2022-07-27 12:02:08.022 EOL: LF, UTF: Auto . 2022-07-27 12:02:08.022 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes; Follow directory symlinks: No . 2022-07-27 12:02:08.022 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No; Exit code 1 is error: No . 2022-07-27 12:02:08.022 SFTP Bugs: Auto,Auto . 2022-07-27 12:02:08.022 SFTP Server: default . 2022-07-27 12:02:08.022 Local directory: default, Remote directory: home, Update: Yes, Cache: Yes . 2022-07-27 12:02:08.022 Cache directory changes: Yes, Permanent: Yes . 2022-07-27 12:02:08.022 Recycle bin: Delete to: No, Overwritten to: No, Bin path: . 2022-07-27 12:02:08.022 DST mode: Unix . 2022-07-27 12:02:08.022 -------------------------------------------------------------------------- < 2022-07-27 12:02:08.022 Script: Searching for host... . 2022-07-27 12:02:08.022 Looking up host "mcklpln5v8k6gjwl2bjmvtlz81jm.ftp.marketingcloudops.com" for SSH connection . 2022-07-27 12:02:08.069 Connecting to 68.232.201.173 port 22 . 2022-07-27 12:02:08.164 Connected to 68.232.201.173 < 2022-07-27 12:02:08.164 Script: Connecting to host... . 2022-07-27 12:02:08.164 We claim version: SSH-2.0-WinSCP_release_5.21 . 2022-07-27 12:02:08.164 Connected to 68.232.201.173 . 2022-07-27 12:02:08.432 Remote version: SSH-2.0-7.9.0.0_openssh GlobalSCAPE . 2022-07-27 12:02:08.432 Using SSH protocol version 2 . 2022-07-27 12:02:08.432 Have a known host key of type rsa2 . 2022-07-27 12:02:08.524 Doing Diffie-Hellman group exchange . 2022-07-27 12:02:08.713 Doing Diffie-Hellman key exchange using 8192-bit modulus and hash SHA-256 with a server-supplied group . 2022-07-27 12:03:10.923 Host key fingerprint is: . 2022-07-27 12:03:10.923 ssh-rsa 3072 SHA256:bFCXgHdgCzL7mYTH8PZoSmYyiq0ryMDkYzk1Z2YfIeE < 2022-07-27 12:03:10.923 Script: Authenticating... . 2022-07-27 12:03:10.923 Host key matches configured key fingerprint . 2022-07-27 12:03:10.923 Initialised AES-256 SDCTR (unaccelerated) [aes256-ctr] outbound encryption . 2022-07-27 12:03:10.923 Initialised HMAC-SHA-256 outbound MAC algorithm . 2022-07-27 12:03:10.923 Initialised AES-256 SDCTR (unaccelerated) [aes256-ctr] inbound encryption . 2022-07-27 12:03:10.923 Initialised HMAC-SHA-256 inbound MAC algorithm . 2022-07-27 12:03:10.923 Remote side sent disconnect message type 11 (by application): "" < 2022-07-27 12:03:10.923 Script: Remote side sent disconnect message < 2022-07-27 12:03:10.923 type 11 (by application): < 2022-07-27 12:03:10.923 "" < 2022-07-27 12:03:10.923 Authentication failed.
