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

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Monday, September 26, 2022 Login
Public

SQL Server Management Studio MFA hanging not prompting 7/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

Invoke-WebRequest https://login.microsoftonline.com

 



Blog Home