You need your MiddCreate SFTP password to use SFTP clients or the terminal to manipulate files on your server. It is a different password than your Middlebury SSO password.
To reset the SFTP password, follow these instructions.