Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSMS 18.1 Azure AD Connection Options Popup

Just installed new SQL Server Management Studio (SSMS) 18.1 GA build. When trying to connect to a Azure SQL instance using Active Directory Universal with MFA Support. After I authenticate using Azure AD, I immediately get a pop up saying "Connection Options" "Azure Active Directory". It asks for an Application ID and Redirect URL and link to Azure Application Registrations.

Screen shot - https://twitter.com/ecpdata/status/1139282704254537730/photo/1

I didn't have these issues in 18 and just tried in 17.9 and don't have the same pop up.

I can cancel out of pop up after a dozen times or so and finally get to the server, just time consuming every time.

like image 497
ECPdata Avatar asked Jun 13 '19 21:06

ECPdata


People also ask

How do I link my Azure SQL managed instance to SSMS?

Connect with SSMSOn the on-premises client computer, open SQL Server Management Studio. In the Connect to Server dialog box, enter the fully qualified host name for your managed instance in the Server name box. Select SQL Server Authentication, provide your username and password, and then select Connect.


1 Answers

Was able to determine the issue is with a plugin that I use within SSMS that isn't compatible with MFA login type. The plugin developer is aware and working on, the issue is not with SSMS itself.

like image 74
ECPdata Avatar answered Sep 20 '22 14:09

ECPdata