Toad World® Forums

Connect using MFA authentication

Hello,
We just use your product which we bought from you. We now want to connect to one of our databases using MFA authentication. How to do so correctly? We tried to pick:

Servername: xxx
Auhentication: Active Directory Pasword authentication
Login: john.doe@xxxxx.com
Password: xxx

Nevertheless it says login failed which is not possible as we correctly connecting from ssms.
please of advice.

Hi,
what OS is it? What version of SQL Server is it? Can you post a screenshot of the error?

I have the same issue. I'm connecting from Windows 10 to Azure SQL Server. In Microsoft SSMS 18.4 there is an authentication option for "Azure Active Directory - Universal with MFA" that works, but this option is not available in Toad for SQL Server 7.1.

Here's the error when trying to connect using Active Directory Password Authentication in Toad.

AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access 'xxx'.

Does Toad plan to have this authentication method available in the future, or is there a work around in Toad?

Hi,

I created ticket TSS-1669 Connect via MFA authentication.
I will implement with high priority

That sounds promising. Thank you. As a licensed user, is there a way I can follow progress on this either through this forum, the ticket you mentioned, or submitting my own ticket?

Hi,
no, we don't have any public facing systems like this. Please ask here in a couple of months or check our release notes whether it's been implemented.