MsSqlConnectionParameters.AuthorizationType Property
Gets or sets the authentication mode of the Microsoft SQL Server.
Namespace: DevExpress.DataAccess.ConnectionParameters
Assembly: DevExpress.DataAccess.v25.2.dll
NuGet Package: DevExpress.DataAccess
Declaration
Property Value
| Type | Description |
|---|---|
| MsSqlAuthorizationType | An MsSqlAuthorizationType value that specifies the authentication mode of the Microsoft SQL Server. |
Available values:
| Name | Description |
|---|---|
| Windows | Authenticate with a Windows user account. |
| SqlServer | Authenticate with a SQL server account. |
| ActiveDirectoryInteractive | Authenticate with a Microsoft Entra ID using interactive authentication. |
| ActiveDirectoryPassword | Authenticate with a Microsoft Entra ID username and password. |
| ActiveDirectoryIntegrated | Authenticate with a Microsoft Entra ID using Integrated Windows Authentication (IWA). |
| ActiveDirectoryDefault | Authenticate with a Microsoft Entra ID using password-less and non-interactive mechanisms such as managed identities, Visual Studio Code, Visual Studio, Azure CLI, and more. |
Remarks
For Microsoft Azure SQL databases, SqlDataSource supports Microsoft Entra (formerly Azure Active Directory) authentication. This authentication method requires use of the Microsoft.Data.SqlClient NuGet package in your application.
Refer to the following help topic for more information about Microsoft Entra authentication settings: Connect to Azure SQL with Microsoft Entra authentication and SqlClient.