Currently having an issue in SQL Server Agent batch jobs running the Reflections SFTP.exe command. Upon execution we are continually receiving the unable to connect to host Ext code 43.
The account running the batch job has the permissions defined in this KB https://support.microfocus.com/kb/doc.php?id=7021931 to no success.
There are no visible errors in Windows Event logs. We can get the job to work when the service account running the job is placed in an administrative group but we would prefer to not keep that account in an administrative group.
The job also seems to work in a pre-production environment with a non-administrator account.
Any help on permissions or anything that could get this SFTP.exe job to work in SQL Server Agent without admin permissions would be greatly appreciated.