To make the Active Directory Password and Active Directory MSI connections Integrated connection from DaticalDB, you need to have the adal.dll
file two files 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 a "Login failed to authenticate the user in Active Directory (Authentication=ActiveDirectoryIntegrated)" error message, 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.
...