dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlAuthenticationMethod Enumeration

On this page
    SqlAuthenticationMethod Enumeration
    On this page
    Determines the authentication method to use when connecting to SQL Azure.
    Syntax
    'Declaration
 
Public Enum SqlAuthenticationMethod 
   Inherits System.Enum
   Implements System.IComparable, System.IConvertible, System.IFormattable 
    public enum SqlAuthenticationMethod : System.Enum, System.IComparable, System.IConvertible, System.IFormattable 
    Members
    MemberDescription
    ActiveDirectoryDefaultThe authentication method uses Active Directory Default. Use this mode to connect to a SQL Database by using multiple non-interactive authentication methods, which are tried sequentially to acquire an access token. This method does not fall back to Active Directory Interactive authentication method.
    ActiveDirectoryDeviceCodeFlowThe authentication method that uses Active Directory Device Code Flow. Use the method to connect to a SQL database from devices and operating systems that don't provide a web browser by using another device to perform interactive authentication.
    ActiveDirectoryIntegratedActive Directory Integrated authentication is used.
    ActiveDirectoryInteractiveActive Directory Interactive authentication is used.
    ActiveDirectoryManagedIdentityThe authentication method uses Active Directory Managed Identity. Use System Assigned or User Assigned Managed Identity to connect to a SQL Database from Azure client environments that support Managed Identity. For User Assigned Managed Identity, set User Id or UID to the client ID of the user-assigned identity.
    ActiveDirectoryMSIAlias for Active Directory Managed Identity authentication method. Use System Assigned or User Assigned Managed Identity to connect to a SQL Database from Azure client environments that support Managed Identity. For User Assigned Managed Identity, set User Id or UID to the client ID of the user-assigned identity.
    ActiveDirectoryPasswordAzure Active Directory principal name and password are used.
    ActiveDirectoryServicePrincipalThe authentication method that uses Active Directory Service Principal. Use the method to connect to a SQL Database using the client ID and secret of a service principal identity.
    ActiveDirectoryWorkloadIdentityThe authentication method uses Active Directory Workload Identity. Use federated User Assigned Managed Identity to connect to a SQL Database from Azure client environments that support Workload Identity. Set User Id or UID to the client ID of the user-assigned identity.
    NotSpecifiedThe authentication method is not specified.
    SqlPasswordSQL password is used.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.SqlServer.SqlAuthenticationMethod

    See Also

    Reference

    Devart.Data.SqlServer Namespace

     

     

    © 2007 - 2026 Devart. All Rights Reserved.

    Send Feedback