Google Authenticator checked, now locked out of DB

Google Authenticator checked, now locked out of DB

avatar

Hello, I accidentally checked the Google Authenticator box under data source, now I can't get back on as it's asking me to configure an authenticator. How can I revert back without having to use my backup? Using SQL2014.

All Comments (2)

avatar

Hi Demetri,

When you open RDM, click on Cancel to close the Google Authenticator Validation box. This will bring you in RDM, but you will not be connected to your data source.

Click on File -> Data Sources and duplicate your SQL data source and disable the 2-Factor Authentication and click on OK.

Try to connect on this copy of your data source configuration. If it's working, you can delete your old data source configuration.

Jeff Dagenais

avatar

When I duplicate the data source, there is no option to disable the 2-factor. When I connect to the copied data source, it does the same thing and bring up the 2-factor authentication.