One of our vendor is updating their Server certificate and provided us with the certificate file which when I open gets installed. Not sure where it gets installed. Earlier we were just using the username/password credentials for connecting to the server. But I am trying to check if we can the connect to the SFTP server using the certificates through the SFTP adapter. If so how do I link the SFTP adapter settings with the installed certificates.
Best Answer
Installed certificates will be in your certificate store, run certmgr to see what certificates are installed. However the BizTalk adapter seems to want the location of the .ppk file.
To use the certificate you will have to configure the Client Authentication Mode to PublicKeyAuthentication and you must enter the private key of the user in the PrivateKey property.
See the Microsoft documentation SFTP Adapter and this blog BizTalk Server 2013 R2: SFTP Adapter Tricks and Pitfalls
For clarity, SFTP does not use Certificates. The options are U/P with server provider key or Private Key.
So, seems they will be sending you a Private Key File they generate which you can import using the Private Key Property on SFTP Transport Properties.