Share via

SqlConnectionInfo.AuthenticationMethod Enum

Definition

Namespace:
Microsoft.SqlServer.Management.Common
Assembly:
Microsoft.SqlServer.ConnectionInfo.dll
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.Data.Tools.Msbuild v16.0.62004.28040
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0
Package:
Microsoft.SqlServer.SqlManagementObjects v172.64.0

The Authentication Method used to log in

public enum SqlConnectionInfo.AuthenticationMethod
type SqlConnectionInfo.AuthenticationMethod = 
Public Enum SqlConnectionInfo.AuthenticationMethod
Inheritance
Enum
SqlConnectionInfo.AuthenticationMethod

Fields

Name Value Description
NotSpecified 0

NotSpecified implies the real authentication type is inferred from other connection string parameters
SqlPassword 1

User id and password are used for SQL login authentication
ActiveDirectoryPassword 2

User id is an Azure AD principal
ActiveDirectoryIntegrated 3

The current AD or Kerberos principal credentials are used to connect
ActiveDirectoryInteractive 5

Uses an interactive UI flow to acquire a token to authenticate. User id is optional.
ActiveDirectoryDeviceCodeFlow 6

Prompt the user to acquire a token from an external device
ActiveDirectoryManagedIdentity 7

Use system assigned or user assigned managed identity to acquire a token.
ActiveDirectoryMSI 7

Alias for ActiveDirectoryManagedIdentity
ActiveDirectoryServicePrincipal 8

User id is the client id of an Azure service principal, and password is the client secret.
ActiveDirectoryDefault 9

Attempts multiple non-interactive authentication methods tried sequentially to acquire an access token. This method does not fallback to the Active Directory Interactive authentication method.

Applies to