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.
| Info |
|---|
As the |
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:
| Code Block |
|---|
C:\\WINDOWS\\System32\\adal.dll |
3. Select OK to save the changes.
| Info |
|---|
If you do not have privileges to copy files to |