Azure Active Directory - Universal with MFA "missing" from SSMS authentication options
I am trying to connect to from SSMS/VS 2022 to a database hosted on Azure. When trying to login via either application, the authentication option "Azure Active Directory - Universal with MFA" is not available, in fact, no Azure Active Directory options are available at all.
The options I have are below... enter image description here
I have made sure "SQL server data tools" are installed.
Versions used (some info removed for brevity) SQL Server Management Studio SQL Server Management Studio 19.2.56.2
Visual Studio 2022 Microsoft Visual Studio Professional 2022 Version 17.8.3 VisualStudio.17.Release/17.8.3+34330.188 Microsoft .NET Framework Version 4.8.04084
Installed Version: Professional
ADL Tools Service Provider 1.0 This package contains services used by Data Lake tools
Azure App Service Tools v3.0.0
Azure Data Lake Tools for Visual Studio 2.6.5000.0 Microsoft Azure Data Lake Tools for Visual Studio
Azure Functions and Web Jobs Tools 17.8.358.6298 Azure Functions and Web Jobs Tools
Azure Stream Analytics Tools for Visual Studio 2.6.5000.0 Microsoft Azure Stream Analytics Tools for Visual Studio
.....
Common Azure Tools 1.10 Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.
......
Microsoft Azure Hive Query Language Service 2.6.5000.0 Language service for Hive query
Microsoft Azure Stream Analytics Language Service 2.6.5000.0 Language service for Azure Stream Analytics
Microsoft Azure Tools for Visual Studio 2.9 Support for Azure Cloud Services projects
......
SQL Server Data Tools 17.8.119.0 Microsoft SQL Server Data Tools
......
Azure Active Directory is now Microsoft Entra ID, refer this link,
Thus select Microsoft Entra MFA as your replacement for Azure Active Directory MFA in SSMS
- SSRS Query execution failed for dataset
- Insert leading spaces, then the value to a varchar(10) column
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?
- Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
- No PK or FK when exporting SQL Server database
- SQL Server SELECT LAST N Rows
- Order by Specific id first then By rest
- Fuzzy phrase similarity in SQL Server
- Union two selects removing duplicates base on some columns (not the full row)
- SQL fill gaps with hold
- Create login and logout rows from single row
- Create Index without name while creating table
- Extracting SQL Server table data to parquet file
- SQL, How to convert VARCHAR to bigint?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- SQL Server query to find all permissions/access for all users in a database
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- inserting data into SQL DB from C# ASP.NET
- Display the average number of days between a customer's last and second to the last transaction
- Fastest way to determine if record exists
- Unrecognized column name that I define
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?