Menu
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.
497
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.
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.
74
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
