Documentation

gitHub

Entra ID authentication

Microsoft Entra IDauthentication supports the following authentication methods:

  • Entra ID cloud-only identities

  • Entra ID hybrid identities that support:

    • Cloud authentication with two options coupled with seamless single sign-on (SSO)

      • Entra ID pass-through authentication
      • Entra ID password hash authentication
    • Federated authentication

 

Further details can also be found here.

 

 

In the Authentication tab of the connection settings dialog, select the applicable Entra ID code flow authentication method:

 

SQL Server - Entrq ID authentication lPCKE

 

 

Granting admin consent

With the Entra ID methods, whether with Username/Password or with MFA, the Azure administrator must grant tenant-wide admin consent to the Hackolade Studio application, as per the documentation page.  Here is a shortcut to the admin consent URL for Hackolade Studio.

 

Image

 

Your IT admin must give consent in order to allow you access to the database.  Consent is required once for the organization.

 

 

Legacy username/password

In the Authentication tab of the connection settings dialog, select the applicable Entra ID legacy authentication method, then provide the username/password and Tenant ID:

 

SQL Server - Entrq ID authentication legqcy

 

 

See instructions on how-to find your tenant ID.