1

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 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: SSMS Q7 Error

I have removed both SSMS 18 and 19 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.

DouadyRabbit
  • 118
  • 7

1 Answers1

1

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.

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.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30