SFTP Private key authentication SAS Code throws ERROR

[Kurt_Bremser]

I would use your .ssh/config file to store such host-specific options; find example documentation here: https://www.digitalocean.com/community/tutorials/how-to-configure-custom-connection-options-for-your... 

[JJP1]

Yes thanks @Kurt_Bremser .Actually i was trying to mention everything including options also in SAS code.

So what can i do please.

Do i need to raise SAS track that SAS SFTP option code is not working ?

or

you want me to setup the options  under .ssh ?

Sorry how can i proceed further from now.

[Kurt_Bremser]

As I said, a segmentation violation points to an internal problem in SAS, and that is the domain of SAS Technical Support.

As a workaround, I recommend running the command from the commandline, and once this works without entering a password, you can use the same (whole) command in a filename pipe. The 2>&1 I added redirects the stderr output to stdout, so that the data step can catch it and write it to the log.

For the sake of simplicity, I recommend to use the ssh config file for host-specific options.

[JJP1]

hi @Kurt_Bremser ,

found that remote server was making use of TLS 1.2 version for FTP connection.

but in my case SAS does not support  TLS 1.2 version and only supports TLS 1.0 verison.

but same connection where SFTP with SSH keys works fine when i ran command via putty application.

but same command gets failed with segmentaion error in SAS EG,do you think it is due to TLS version please..

So If it is due to TLS version may i know why & how please.

[Kurt_Bremser]

As I said, get it to run from the commandline, and then use the whole commandline command in a filename pipe from SAS; all the work is done outside SAS, and SAS only fetches the results.

[JJP1 · Accepted solution]

I was using private key name as  very long ***********************************.com.So tried by shortening the key name as ***.key and it works fine in SAS and able to connect to remote server successfully.

Just a blind guess and did not expected that it would work..I really can't understand why it worked and not giving correct error also in SAS log.

Special Thank you @Kurt_Bremser .