To make Active Directory Password and Active Directory MSI connections from DaticalDB, you need to have the adal.dll file in C:\Windows\System32. For the Active Directory Integrated connection, you need two files - adal.dll and mssql-jdbc_auth-<version>.<arch>.dll.
If you receive an "Unable to load adalsql.dll" error message after downloading the adal.dll file and copying it to C:\Windows\System32, you will need to add an entry for adal.dll in the Windows registry.
As the adalsql.dll file is outdated, the adal.dll should be used instead.
To add the adal.dll entry in the Windows registry:
Enter Registry Editor in the Windows search box on the taskbar and open the Registry Editor app. If you are prompted by User Account Control, select Yes.
Navigate to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSADALSQL, double-click theTargetDirfile, and then add the following path:
C:\\WINDOWS\\System32\\adal.dll
3. Select OK to save the changes.
If you do not have privileges to copy files to C:\Windows\System32 or to run the Registry Editor, contact your IT support group for assistance.