Home
%3CLINGO-SUB%20id%3D%22lingo-sub-369179%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2366%3A%20Azure%20Active%20Directory%20-%20Universal%20with%20MFA%20authentication%20-%20Output%20Window%20Trace%20Level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369179%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jan%2023%2C%202019%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20Hello%20Team%2C%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20I%20worked%20on%20a%20service%20request%26nbsp%3Bwhere%20our%20customer%20faced%20a%20connectivity%26nbsp%3Bissue%20using%20Active%20Directory-%20Universal%20with%20MFA%20authentication.%20After%20our%20basic%26nbsp%3Btroubleshooting%20we're%20used%20to%20suggest%20taking%20a%26nbsp%3Bnetwork%20and%20https%20traces%26nbsp%3Bin%20order%20to%20review%20the%20communication%20between%20the%26nbsp%3BApplication%2C%20Azure%20Active%20Directory%20and%20%26nbsp%3BDatabase%20server.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20I%20found%20a%20very%20useful%26nbsp%3Boption%20in%26nbsp%3BSQL%20Server%20Management%20Studio%20that%20you%20could%20create%20an%20ADAL%20tracing%20that%20is%20available%20beginning%20with%20SQL%20Server%20Management%20Studio%20SMS%2017.3.%20Off%20by%20default%2C%20you%20can%20turn%20on%20ADAL%20tracing%20by%20using%20the%20Tools%2C%20Options%20menu%2C%20under%20Azure%20Services%2C%20Azure%20Cloud%2C%20ADAL%20Output%20Window%20Trace%20Level%2C%20followed%20by%20enabling%20Output%20in%20the%20View%20menu.%20The%20traces%20are%20available%20in%20the%20output%20window%20when%20selecting%20Azure%20Active%20Directory%20option.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F89108i92E9A704AACEA7D5%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Very%20nice%20option%20when%20we%20have%20this%20type%20of%20problem.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Enjoy!!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-369179%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jan%2023%2C%202019%20Hello%20Team%2CI%20worked%20on%20a%20service%20request%26nbsp%3Bwhere%20our%20customer%20faced%20a%20connectivity%26nbsp%3Bissue%20using%20Active%20Directory-%20Universal%20with%20MFA%20authentication.%3C%2FLINGO-TEASER%3E
First published on MSDN on Jan 23, 2019
Hello Team,

I worked on a service request where our customer faced a connectivity issue using Active Directory- Universal with MFA authentication. After our basic troubleshooting we're used to suggest taking a network and https traces in order to review the communication between the Application, Azure Active Directory and  Database server.

I found a very useful option in SQL Server Management Studio that you could create an ADAL tracing that is available beginning with SQL Server Management Studio SMS 17.3. Off by default, you can turn on ADAL tracing by using the Tools, Options menu, under Azure Services, Azure Cloud, ADAL Output Window Trace Level, followed by enabling Output in the View menu. The traces are available in the output window when selecting Azure Active Directory option.



Very nice option when we have this type of problem.

Enjoy!!