Connect using MFA authentication

Up vote, I switched from Oracle to MS and would love to keep working using TOAD.

Hello, is there any update about this? This feature is very important because nowadays connect to a Azure SQL Server database with 2FA is very common, and without this feature for this I must to use "SQL Server Management Studio" sadly :frowning: Thanks.

Hi everyone,
We're sorry for the delay but the MFA authentication support is coming up in Toad version 8.0. It's currently scheduled for mid-year. Please look out for product notifications.

Hi - do you have any more info on when version 8.0 is planned to be released? And does it for sure include MFA authentication?
Thanks

Hi,

The Toad for SQL Server 8.0 is scheduled for early July this year, targeting the 10th of July right now, keep an eye out for product update notifications.

Hello, I've encountered an issue using Toad for SQL Server 8.0.

• I am trying to connect to a database using “Active Directory Universal with MFA” authentication protocol

• When passing in a Redirect URL, Toad continues to try to authenticate against Azure using the common endpoint causing us to run into the below error (ids redacted for confidentiality)

Application 'redacted'(redacted) is not configured as a multi-tenant application. Usage of the /common endpoint is not supported for such applications created after '10/15/2018'. Use a tenant-specific endpoint or configure the application to be multi-tenant.

It seems as though the Redirect URL is being ignored during the authentication process.

• Connection Properties are attached

Hello,
I have same problem using Toad 8.1. Unfortunately there seem no detailed instructions for Toad exist how to get that Application ID or just any useful information about Toad and MFA. Microsoft SQL Server Management Studio connects using MFA without asking for an Application ID. I assume there's a standard application ID for SSMS, but for Toad this is missing.

Therefore I have registered Toad myself as application in our Azure Tenant and now got stuck with the AADSTS50194 error suggesting using that tenant specific endpoint. I guess that Redirect URI is meant, and this doesn't work as Zareh has described.

I was asked for my business case for using Toad instead of SSMS. Without being able to connect with Toad to our highly secured databases using MFA I have not too much options to keep Toad license.

Kind regards,
Arno