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 "Login failed to authenticate the user in Active Directory (Authentication=ActiveDirectoryIntegrated)", you may need to add a
mssql-jdbc_auth-<version>.x64.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\MSJDBCAUTHDLL
, double-click theTargetDir
file, and then add the following path:
Code Block |
---|
C:\\WINDOWS\\System32\\mssql-jdbc_auth-<version>.x64.dll |
3. Select OK to save the changes.
Info |
---|
If you do not have privileges to copy files to |
If you receive an "Unable to load adalsql.dll" error message after downloading the
adal.dll
file and copying it toC:\Windows\System32
, you will need to add an entry foradal.dll
in the Windows registry.
Info |
---|
As the |
...
Code Block |
---|
C:\\WINDOWS\\System32\\adal.dll |
...
...
Select OK to save the changes.
Info |
---|
If you do not have privileges to copy files to |
...