Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can test the connection either by using the Test Connection button in the GUI or by running
hammer testConnect <dbDef> from the command line.

...

Info

If you

...

  • 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 the TargetDir file, and then add the following path:

      Code Block
      C:\\WINDOWS\\System32\\mssql-jdbc_auth-<version>.x64.dll
    • Select OK to save the changes.

Info

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.

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

    • 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 the TargetDir file, and then add the following path:

      Code Block
      C:\\WINDOWS\\System32\\adal.dll
    • Select OK to save the changes.

Info

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 assistancehave any issues, refer to Troubleshooting Issues with Active Directory Authentication and Azure SQL Database.

Active Directory Password Authentication

...