MsSqlConnectionParameters.AuthorizationType Property

Gets or sets the authentication mode of the Microsoft SQL Server.

Namespace: DevExpress.DataAccess.ConnectionParameters

Assembly: DevExpress.DataAccess.v24.2.dll

NuGet Package: DevExpress.DataAccess

Declaration

C#

public MsSqlAuthorizationType AuthorizationType { get; set; }

VB.NET

Public Property AuthorizationType As MsSqlAuthorizationType

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.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the AuthorizationType property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

web-dashboard-display-the-total-value-above-each-pie-chart/CS/ASPxDashboard/Default.aspx.cs#L20

if (cp != null && cp.DatabaseName == "Northwind") {
    cp.AuthorizationType = MsSqlAuthorizationType.SqlServer;
    cp.ServerName = ".\\sql2016";

VB.NET

web-dashboard-display-the-total-value-above-each-pie-chart/VB/ASPxDashboard/Default.aspx.vb#L22

If cp IsNot Nothing AndAlso cp.DatabaseName = "Northwind" Then
    cp.AuthorizationType = MsSqlAuthorizationType.SqlServer
    cp.ServerName = ".\sql2016"