This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 0%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
@ADALTeam I’m not able to connect to my Azure database using “Azure Active Directory – Integrated” when using SSMS 17 or x86 ODBC connections, but I’m able to connect with SSMS 19 and x64 ODBC connections.
I know this has been discussed extensively before, my issue is similar to this posting unable-to-load-adalsql-dll-error-when-calling-invoke-sqlcmd
In my case the x86 applications are not working and the x64 are fine. All of this seem to have started after installing SSMS 19, I removed everything and started from scratch but that did not help. I have followed the recommendations on the posting above with no luck. It seems that I have everything I need, but I can’t pinpoint what the issue is or what is that I’m missing, I have:
Both x86 and x64 ADAL files, I have also tried with each one without the other on my system:
C:\Windows\SysWOW64\AdalSQL.dll
C:\Windows\System32\AdalSQL.dll
…and their Registry entries is there:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSADALSQL]\TargetDir = C:\WINDOWS\system32\adalsql.dll
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSADALSQL]\TargetDir =
C:\WINDOWS\SysWOW64\adalsql.dll
When I use SSMS 17 I get this message:
This is probably a mismatched DLL issue; how can I check where the issue is?
An Azure relational database service.
A cloud-based identity and access management service for securing user authentication and resource access
Answer accepted by question author
Please read below.
If any of your applications use the Azure Active Directory Authentication Library (ADAL) for authentication and authorization functionality, it's time to migrate them to the Microsoft Authentication Library (MSAL).
All Microsoft support and development for ADAL, including security fixes, ends in December, 2022.
For more information, please read here.
Hi @Alberto Morillo , thank you for replying, I'm in the process of migrating our legacy system to a web solution, in the meantime there are some critical applications that need this functionality, I need to make this work until all applications are migrated. I don't know what is broken, all I know is that this was working fine until I installed SSMS 19 and/or VS2022. Removing those apps doesn't fix this issue, apparently the change is permanent.
Luis
The change is indeed permanent. As you can read here Microsoft intended to end support back in June 2022, but it extended support 6 months more. Have you considered to quickly migrating to MSAL.
You are welcome! Thank you for visiting Microsoft QA