We are using SQL SERVER 2008 job to call batch file which is doing (Tectia) SFTP (pull) for txt file. When we are running independent batch file it is working fine but when we tried to call the same batch file using SQL Server Job it is throwing error "Could not connect to SFTP Server"
We are using sftpg3.exe -B "C:Tempgetftp.bat" --password=Password@12 firstname.lastname@example.org#22 It also gives below message "Supplying the password on the command line is VERY insecure. Ina multi-user environment, the password is trivial to recover from the process table. You should set up a more secure way to authenticate. "publickey" authentication, certificates,"hostbased" authentication and "gssapi" can all provide non-interactive authentication in a secure way...
We do not want to any third party software to do this job. Does SQL SERVER Supports SFTPG3.exe ? Any one has any clue how to resolve above error about it kindly help.
asked Dec 30 '11 at 14:12
You could try and solve this in a different way. If you execute the batch script, instead of executing sftpg3.exe first. For example:
If you want to get rid of the error regarding the password you should try and setup public key user authentication, as this does not require a password used on the command line.
Hope this helps.
This answer is marked "community wiki".
answered Jan 02 '12 at 10:44