AuthScheme
The scheme used for authentication. Accepted entries are Password, AzureAD, AzureServicePrincipal, AzureServicePrincipalCert, AzureMSI, AzurePassword.
Possible Values
AzureAD, AzureMSI, AzureServicePrincipal, AzureServicePrincipalCert, Password, AzurePasswordData Type
string
Default Value
"Password"
Remarks
- AzureAD: Set this to perform Azure Active Directory OAuth authentication.
- AzureMSI: Set this to automatically obtain Managed Service Identity credentials when running on an Azure VM.
- AzureServicePrincipal: Set this to authenticate as an Azure Service Principal using a Client Secret.
- AzureServicePrincipalCert: Set this to authenticate as an Azure Service Principal using a Certificate.
Together with Password and User, this field is used to authenticate against the server. Password is the default option. Use the following options to select your authentication scheme:
- Password: Set this to use your SQL Server Password.
- AzureAD: Set this to use Azure Active Directory OAuth authentication.
- AzureServicePrincipal: Set this to authenticate as an Azure Service Principal.
- AzureServicePrincipalCert: Set this to authenticate as an Azure Service Principal using a certificate.
- AzureMSI: Set this to use Azure Active Directory Managed Service Identity authentication.
- AzurePassword: Set this to use Azure Active Directory Password authentication.