Specifies the scheme used to authenticate the connection to SQL Server.

Possible Values

Password, NTLM, Kerberos, AzurePassword, AzureAD, AzureMSI, AzureServicePrincipal, AzureServicePrincipalCert, AKSWorkloadI

Data Type

string

Default Value

"Password"

Remarks

This property determines how the driver authenticates with SQL Server. It must be used in combination with the User and Password properties, except when using methods that rely on identity-based authentication, such as AzureMSI.

Authentication schemes control which credentials or tokens are expected and how they're validated by the server.

The following values are supported:

• Password: Set this to use your SQL Server Password.
• NTLM: Set this to use NTLM authentication.
• Kerberos: Set this to use Kerberos authentication.
• AzurePassword: Set this to use Azure Active Directory Password authentication.
• AzureAD: Set this to use Azure Active Directory OAuth authentication.
• AzureMSI: Set this to use Azure Active Directory Managed Service Identity authentication.
• AzureServicePrincipal: Set this to authenticate as an Azure Service Principal.
• AzureServicePrincipalCert: Set this to authenticate as an Azure Service Principal using a certificate.
• AKSWorkloadI: Set this to use Workload Identity Federation authentication.

Additional Information

Some authentication schemes, such as AzureMSI or AzureServicePrincipalCert, may require additional properties (such as OAuthClientId and OAuthClientSecret). See individual property descriptions for details.