Specifies which authentication scheme the driver uses when it establishes the connection.

Possible Values

Password, AzureAD, AzureServicePrincipal, AzureServicePrincipalCert, AzureMSI, AzurePassword

Data Type

string

Default Value

"Password"

Remarks

Azure Synapse supports the following AuthScheme options:

• Password (default): Authenticate using your username and your SQL Server Password.
• AzureAD: Perform Azure Active Directory (user-based) OAuth authentication.
• AzureServicePrincipal: Authenticate as an Azure Service Principal (role-based, application-based) using a Client Secret.
• AzureServicePrincipalCert: Authenticate as an Azure Service Principal (role-based, application-based) using a Certificate.
• AzureMSI: Automatically obtain Azure AD Managed Service Identity (MSI) credentials when running on an Azure VM.
• AzurePassword: Authenticate directly to Azure Active Directory using your Azure user name and password, and the Directory ID of the Azure Tenant.