Troubleshooting Issues with Active Directory Authentication and Azure Managed Instance

To make the Active Directory Integrated connection from DaticalDB, you need to have two files in C:\Windows\System32 - adal.dll and mssql-jdbc_auth-<version>.<arch>.dll.

• If you receive 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:

1. 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.

2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSJDBCAUTHDLL, double-click the TargetDir file, and then add the following path:

   C:\\WINDOWS\\System32\\mssql-jdbc_auth-<version>.x64.dll

3. Select OK to save the changes.

• 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.

To add the adal.dll entry in the Windows registry:

1. 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.

2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSADALSQL, double-click the TargetDir file, and then add the following path:

   C:\\WINDOWS\\System32\\adal.dll

Open

3. Select OK to save the changes.