SFTP ERROR: Connection refused, check key authentication and sshd server status.

[duanzongran]

HI! friends!

now,my sas is installed on a win7 OS  PC,and i want to connect to a SFTP(linux)  to read a csv_file(import a csv_file to my work library for data analysis);

i can read the csv_file by using putty, comand as follows:
GET /home/mypath/csv_file.csv

in BASE SAS, i tried to import the csv_file to my work library ,the code is just  like this :

filename lin  sftp '/home/fengxian/gpa.csv' host="10.50.100.34" user="fengxian"  ;

data ll;

infile lin delimiter=',',firstobs=2 ;

input nobs gpa hsm hss hse satm satv gender;

run;

but,the log is 

ERROR: Connection refused, check key authentication and sshd server status.

any suggestion is welcom!

thanks in advance!

[Kurt_Bremser · Accepted solution]

You need to set up public/private key authentication for that connection in putty. putty must not ask for a password when you test it from the commandline.

[duanzongran]

Thank you so much Mr.Kurt Bremser !