Blog Post

SQL Server Blog
2 MIN READ

SQL Server Management Studio (SSMS) 19.0 Released!

erinstellato's avatar
erinstellato
Icon for Microsoft rankMicrosoft
Jan 26, 2023
The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here!       This is the recommended release for SQL Server 2022, and it includes support for combability leve...
Snag_5761c90.png
Updated Feb 03, 2025
Version 2.0
sqlserver2022
sqltools
albertozgz's avatar
albertozgz
Copper Contributor
Jul 12, 2023

erinstellato 

 

"Error loading adal.dll"  (SSMS 19.1.56)

 

 

Hello

For the Import / Export wizard of SSMS

To connect to Azure Database with 2FA, you need Choose "Microsoft OLE DB Driver for SQL Server"

 

Unfortunately, looks like ADAL libraries has been deprecated on Dec 2022

 

As far as I know any of the other drivers are compatible with Az DB & AAD 2FA:

 

 

am I missing something?