# Connect using MFA authentication **URL:** \ **Category:** Toad for SQL Server\ **Created:** [November 26, 2019, 10:29am UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284 "2019-11-26T10:29:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![toadsqlserver\_user](https://avatars.discourse-cdn.com/v4/letter/t/e19adc/32.png) [@toadsqlserver\_user](https://forums.toadworld.com/u/toadsqlserver_user)\ **Post date:** [November 26, 2019, 10:29am UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/1 "2019-11-26T10:29:29Z")
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](mailto:john.doe@xxxxx.com) Password: xxx Nevertheless it says login failed which is not possible as we correctly connecting from ssms. please of advice. ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [November 26, 2019, 11:50am UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/2 "2019-11-26T11:50:22Z")
Hi, what OS is it? What version of SQL Server is it? Can you post a screenshot of the error? ---
**Author:** ![borateen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/borateen/32/11926_2.png) [@borateen](https://forums.toadworld.com/u/borateen)\ **Post date:** [January 14, 2020, 7:36pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/3 "2020-01-14T19:36:49Z")
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? ---
**Author:** ![VasiliyFofanov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vasiliyfofanov/32/10873_2.png) [@VasiliyFofanov](https://forums.toadworld.com/u/VasiliyFofanov)\ **Post date:** [January 16, 2020, 6:17am UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/4 "2020-01-16T06:17:53Z")
Hi, I created ticket TSS-1669 Connect via MFA authentication. I will implement with high priority ---
**Author:** ![borateen](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/borateen/32/11926_2.png) [@borateen](https://forums.toadworld.com/u/borateen)\ **Post date:** [January 22, 2020, 7:32pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/5 "2020-01-22T19:32:24Z")
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? ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [January 23, 2020, 2:09pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/6 "2020-01-23T14:09:13Z")
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. ---
**Author:** ![matt.mcdonald](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@matt.mcdonald](https://forums.toadworld.com/u/matt.mcdonald)\ **Post date:** [August 3, 2020, 3:17pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/7 "2020-08-03T15:17:12Z")
Any update on this feature? ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [August 4, 2020, 1:18pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/8 "2020-08-04T13:18:32Z")
Hi Matt, we need to upgrade our .NET libraries to 4.7.2 to implement this and while we are defeinitely going to do it sometime soon, we're not doing the upgrade just yet. ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [August 25, 2020, 10:22pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/9 "2020-08-25T22:22:58Z")
When you say "soon", does that mean weeks? Months? I ask because we're moving all of our databases over to Azure, and I really like the DataPoint tool - just wondering if I'm going to have to start searching for another tool again. Thanks! ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [August 26, 2020, 11:56am UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/10 "2020-08-26T11:56:38Z")
More than a month before a release contains .NET 4.7.2 (but it does not have to be much more than that based on priority). Thanks for adding up to priority of this. I'll try and get a more precise timing. ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [September 18, 2020, 3:52pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/11 "2020-09-18T15:52:39Z")
Dan - any further information on this? ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [October 2, 2020, 4:51pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/12 "2020-10-02T16:51:36Z")
Looks like this isn't in the version that was released yesterday. Any update on when it will be available? ---
**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\ **Post date:** [October 5, 2020, 10:32am UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/13 "2020-10-05T10:32:05Z")
Hi David, sorry, but it will not be this year. Do you think you yould set up a support request for an enhancement to boost its priority? ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [October 5, 2020, 3:00pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/14 "2020-10-05T15:00:06Z")
Thanks for the reply, Dan. I probably won’t bother creating a request, because I’ll need something before the end of the year – guess it’s time to move on to another tool. ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [September 8, 2021, 9:23pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/15 "2021-09-08T21:23:19Z")
Almost another year - just thought I'd check and see if there's a plan to support Azure databases. ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [November 1, 2021, 5:54pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/17 "2021-11-01T17:54:56Z")
Is there still a plan to make this functionality available? ---
**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\ **Post date:** [November 1, 2021, 6:35pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/18 "2021-11-01T18:35:07Z")
Hi David, We are planning for a new release at the beginning of the next year. I'll check with the team if this change can make it to the next release. Please stay tuned. ---
**Author:** ![dave.stacionis](https://avatars.discourse-cdn.com/v4/letter/d/7feea3/32.png) [@dave.stacionis](https://forums.toadworld.com/u/dave.stacionis)\ **Post date:** [December 28, 2021, 4:02pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/19 "2021-12-28T16:02:04Z")
I too need this feature in order to use Toad for SQL Server. I really prefer TOAD as I am very familiar with it and up to now have not needed to do much with SQL Server. ---
**Author:** ![dbean](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dbean](https://forums.toadworld.com/u/dbean)\ **Post date:** [February 15, 2022, 10:11pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/20 "2022-02-15T22:11:32Z")
Looks like this didn't make it in again? Any word on when it might? It says above that it had "high priority" two years ago. Thanks! ---
**Author:** ![sallie.cottingham](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@sallie.cottingham](https://forums.toadworld.com/u/sallie.cottingham)\ **Post date:** [July 5, 2022, 6:20pm UTC](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284/21 "2022-07-05T18:20:06Z")
Is there any update on this? We recently did a trial of Toad for SQL Server and this would have been a deal breaker since we have a good number of Azure SQL Databases. But we were told that MFA support was 'coming soon'. I just now found this thread and see that it has been coming soon since 2019. There is a post about this from January 2020 that says: I created ticket **TSS-1669** Connect via MFA authentication. I will implement with high priority. What is the status of this ticket?? [Next page](https://forums.toadworld.com/t/connect-using-mfa-authentication/48284.md?page=2)