The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog



No Ads ever, except search!
Saturday, July 20, 2024 Login

Blog posts for the month of July,2022.
Honda CTX 700 20147/25/2022 10:52:38 AM
New to me !
Honda CTX 700 2014

SQL Server Management Studio MFA hanging not prompting7/12/2022 5:58:15 AM

We have certain "zones" / "restrictions" that cause us too use a common "jump box" (server). 

Sometimes SQL Server Management Studio SSMS hangs when using Multi Factor Authentication to access Azure SQL resources.  The prompts for logging in never appear.  ( Make sure the URL's for Microsoft are white listed).

This appeared to only affect some users.

Internet Explorer is "retired", but it appears that SSMS still uses some calls to IE underneath the hood to call MFA.

The team was able to find a workaround that users can compete to clean up a bad cookie that seems to be the ultimate culprit. Details on this fix are below:


Executing the below commands in a Powershell window. – If you have never ran Internet explorer on the server before, do that before running the command. E.g open IE and close it, the run the below.


RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 1

start-sleep 2

RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 2

start-sleep 2

RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8

start-sleep 5


[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12



Blog Home