Thread Details

 Is there a way to handle SFDC two-factor verification code when connecting?

Post by dmflad
Joined 2/18/2018
Posted 2/20/2018 10:12 AM

Is there a way for VSS's SOQL Studio to handle 2-factor-authentication (2FA or TFA)?  My Org requires it as part of initial login.

Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 2/20/2018 10:50 AM
Yes, SOQL Studio can connect to Salesforce with accounts that require Two-Factor Authentication for API Logins. To do so, update the org's Login Information (in Manage Organizations) as follows:
  • Delete the value in the Password field, if specified
  • Uncheck "Remember Password"
  • Delete the value in the "Security Token" field, if specified
  • Click OK to save the changes
Using this setup, you will be prompted for a password when you first connect to the org.  In the Password dialog enter your password and the TFA verification code.  For example, assuming a password of "MySecret123Password" and a verification code of "987 456" you would enter "MySecret123Password987456" when prompted for your password.
However, the user experience with TFA in SOQL Studio could probably be better, so this has been added to our enhancements list.
Post by Administrator
Visual Software Systems
Joined 1/01/2016
Posted 4/24/2018 10:43 PM

SOQL Studio now has native support for Two-Factor Authentication beginning with v2018.1 build 261

Log in to reply to this post.