Depending on the authentication mechanism used in your environment, additional steps may be required to configure authentication.

The driver supports the following authentication methods:
  • UserID/Password authenticates using the specified user IDs and passwords.
  • Kerberos authenticates based on the value specified for the LoginConfigName property to establish a Kerberos connection.
  • NTLM authenticates using NTLMv1 or NTLMv2 depending on the size of the NTLM password.
  • Access token authenticates the user with an access token obtained from the Microsoft Entra ID (Azure Active Directory).
  • Microsoft Entra ID authentication (formerly Azure Active Directory Authentication) authenticates using Microsoft Entra ID (Entra ID) authentication when establishing a connection to Azure. The driver supports the following methods of Entra ID authentication:
    • User and password authentication
    • Service principal user authentication
    • Managed identity authentication

By default, the driver is configured to use the user ID/password authentication, access token authentication, or Kerberos authentication based on the connection properties provided (AuthenticationMethod=auto).