ssms microsoft MFA dialog box does not show up

Question

ssms microsoft MFA dialog box does not show up

Vladislav Hrdina 25

Hi,

I just had my work laptop reinstalled with new system to Windows 11 (from W10)

I'm using sql server management studio to connect to the database using the Microsoft Entra MFA Authentication option. When I provide the account name and hit connect, the window is in sort of "in progress" state as seen on the attached file and the dialog window where I'd provide the password does not show up.

Basically I was able to log in in the morning to database on W10 just fine, but I was not able to do it few hours later on W11. Initially I tried it on newest version of smss, but then I downgraded to my previous 19.3 version.

When using the Azure Data Studio, I'm able to access the database just fine using the same log in details, so I'm wondering if there's something wrong with either the W11 instance, my account or something else.

Accepted answer

1 additional answer

Your answer

Answer 1

Vinodh247 34,661 MVP Volunteer Moderator

Thanks Vladislav Hrdina

Glad to know that you were able to figure this out and thanks for sharing the rootcause. By the way, Microsoft Q&A community has a policy that "The question author cannot accept their own answer, they can only accept answers by others.". Hence request you to accept this as an answer so we can close this thread. I am summarizing the issue and root cause you have found for it.

Issue Summary: After reinstalling Windows 11, I can't connect to the database via SQL Server Management Studio using Microsoft Entra MFA, though Azure Data Studio works fine with the same credentials.

Fix: Resolved the issue by creating a local profile for the Lieberman account, switching the default browser to Chrome, which successfully loaded the database page.

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-09-02T14:35:55.92+00:00

Vladislav Hrdina: You will have to 'Accept' the above as an answer, so we can close this. Let me know if you dont see that option.

Answer 2

Vinodh247 34,661 MVP Volunteer Moderator

Hi Vladislav Hrdina,

Thanks for reaching out to Microsoft Q&A.

Check SSMS Version: Ensure you are using SSMS version 18.6 or later, as earlier versions do not support Microsoft Entra authentication with MFA. You mentioned using version 19.3, which is compatible, but confirm that it is the latest version available.
Clear SSMS Cache: Clear the cache for SSMS. Navigate to the following directory and delete the contents:
```
   %AppData%\Microsoft\SQL Server Management Studio
```
After clearing the cache, restart SSMS and try connecting again.
1. Windows Credential Manager: Open Windows Credential Manager and remove any stored credentials related to your Azure account. This can help resolve issues with expired or incorrect credentials.
Firewall Configuration: Ensure that your corporate firewall allows traffic on port 1433, which is the default port for SQL Server connections. If you are behind a corporate firewall, this could be blocking the connection.

Additional Troubleshooting Steps

Re-register MFA: If the issue persists, consider re-registering your MFA settings. This may involve logging into your Azure account and ensuring that MFA is correctly configured for your user account.
Use Azure Data Studio: Since you mentioned that Azure Data Studio works fine with the same credentials, it may be beneficial to continue using it if the problem with SSMS cannot be resolved quickly.
Check for Updates: Ensure that your Windows 11 installation is fully updated, as there may be compatibility patches or updates that could resolve issues with SSMS.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

Vladislav Hrdina 25 Reputation points

2024-08-19T15:53:46.5633333+00:00

Hi,

thank you for your reply. Indeed my version is more recent than 18.6. I confirm that I had the newest version which was 20+ and I downgraded back to 19.3.4.

There were no caches data either, because it was fresh Windows installation.

I also have all the available updates installed.

It was already confirmed by one of our IT guys that the port 1433 indeed seems to be blocked, which I guess is somewhat specific to the current Windows 11 instance on my laptop, otherwise I cannot explain why that MFA authentication worked previously.
I've already contacted service desk with a request to unblock it. I'll wait whether that helps or not.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-08-20T04:31:45.8233333+00:00

okay, pls update here how it goes
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-08-25T00:13:30.91+00:00

hey Vladislav Hrdina: how are you doing? how did it go?
Vladislav Hrdina 25 Reputation points

2024-08-26T17:05:04.7133333+00:00

Hi @Vinodh247 - I'm still waiting for response from Service Desk. I did however test it out with my dba colleague who has the access to the same database and was part of the same batch for Windows 11 upgrade. He was facing the same issues. He then played around with the firewall by shutting it off and adding the exception for the SSMS application and it worked for him. However when he tried to replicate the same process on my system, it did not work. I don't know if it has something to do with the elevated access rights on his account. We'll still keep trying locally until we get a response from Service Desk.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-08-27T04:48:27.2233333+00:00

okay, let me know once you have heard from your service desk
Sai Raghunadh M 4,635 Reputation points Microsoft External Staff Moderator

2024-08-29T14:42:12.3433333+00:00

Hi @ Vladislav Hrdina,If you have opened a support ticket, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thankyou.
Vladislav Hrdina 25 Reputation points

2024-09-02T08:05:47.7533333+00:00

@Sai Raghunadh M I was referring to our internal service desk, not affiliated with Microsoft :)

Anyway, we managed to fix the problem ourselves eventually.

To connect to the database, I'm using lieberman account. To get the dialogue window with login/password to pop-up, I had to log in as the lieberman user to the system and have a local profile created.
After that, the window was showing up, however it could not load the page at all. It was opening the window in Edge browser. However Chrome loaded it just fine. So I set the default browser on the second account to Chrome and that fixed the issue.
Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2024-09-02T08:15:32.7533333+00:00

Thanks Vladislav Hrdina.

Would like to ask if you are okay to close this thread by accepting an answer. If okay i can write up a answer that would summarise the question and the solution tried. Let me know.
Vladislav Hrdina 25 Reputation points

2024-09-02T08:46:24.3166667+00:00

@Vinodh247 sure, go ahead :)
Vladislav Hrdina 25 Reputation points

2024-09-02T11:03:05.74+00:00

Hi @Vinodh247 Thanks, that's completely fine. I accept that answer and you can close this thread.

Share via

ssms microsoft MFA dialog box does not show up

1 additional answer

Your answer