MsSqlAuthorizationType Enum

Lists values that specify the authentication mode of the Microsoft SQL Server.

Namespace: DevExpress.DataAccess.ConnectionParameters

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public enum MsSqlAuthorizationType

VB.NET

Public Enum MsSqlAuthorizationType

Members

Name	Description
Windows	Authenticate with a Windows user account.
SqlServer	Authenticate with a SQL server account.

Related API Members

The following properties accept/return MsSqlAuthorizationType values:

Library	Related API Members
Cross-Platform Class Library	MsSqlConnectionParameters.AuthorizationType
WPF Controls	ConnectionPropertiesPage.AuthTypeMsSql

Remarks

Values listed by this enumeration are used to set the MsSqlConnectionParameters.AuthorizationType property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the MsSqlAuthorizationType enum.

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#

how-to-define-iconnectionstorageservice-filtering-unnecessary-connections-from-appconfig-t281449/CS/WizardConnectionStorageService/Form1.cs#L33

ServerName = "localhost",
AuthorizationType = MsSqlAuthorizationType.Windows,
DatabaseName = "Northwind"

how-to-configure-the-sql-data-access-component-in-code-to-bind-the-gridcontrol-to-a-databa-t190498/CS/dxSample/Form1.cs#L41

private static SqlDataSource InitData() {
    MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters("localhost", "nwind.mdf", "username", "password", MsSqlAuthorizationType.SqlServer);
    SqlDataSource ds = new SqlDataSource(connectionParameters);

winforms-end-user-designer-how-to-customize-the-data-source-wizard-connection-string-stora-t119350/CS/T119350/CustomConnectionStorageService.cs#L38

//Add a connection to the XML file:
SqlDataConnection defaultConnection = new CustomSqlDataConnection("Default Connection", new MsSqlConnectionParameters("localhost", "NORTHWIND", "sa", "dx", MsSqlAuthorizationType.SqlServer));
SaveConnection(defaultConnection.Name, defaultConnection, true);

Reporting_how-to-provide-aspxreportdesigner-with-the-sqldatasource-objectdatasource-t271722/CS/WebApplication1/Default.aspx.cs#L18

MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(".", "NWind", null, null, MsSqlAuthorizationType.Windows);
DevExpress.DataAccess.Sql.SqlDataSource ds = new DevExpress.DataAccess.Sql.SqlDataSource(connectionParameters);

how-to-display-the-total-value-above-each-pie-chart-t543185/CS/ASPxDashboard/Default.aspx.cs#L20

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

VB.NET

how-to-define-iconnectionstorageservice-filtering-unnecessary-connections-from-appconfig-t281449/VB/WizardConnectionStorageService/Form1.vb#L29

Dim cpNorthwind As New MsSqlConnectionParameters() With {.ServerName = "localhost", .AuthorizationType = MsSqlAuthorizationType.Windows, .DatabaseName = "Northwind"}
Dim cpAdventureWorks As New MsSqlConnectionParameters() With {.ServerName = "localhost", .AuthorizationType = MsSqlAuthorizationType.Windows, .DatabaseName = "AdventureWorksDW2012"}

how-to-configure-the-sql-data-access-component-in-code-to-bind-the-gridcontrol-to-a-databa-t190498/VB/dxSample/Form1.vb#L43

Private Shared Function InitData() As SqlDataSource
    Dim connectionParameters As New MsSqlConnectionParameters("localhost", "nwind.mdf", "username", "password", MsSqlAuthorizationType.SqlServer)
    Dim ds As New SqlDataSource(connectionParameters)

winforms-end-user-designer-how-to-customize-the-data-source-wizard-connection-string-stora-t119350/VB/T119350/CustomConnectionStorageService.vb#L40

'Add a connection to the XML file:
Dim defaultConnection As SqlDataConnection = New CustomSqlDataConnection("Default Connection", New MsSqlConnectionParameters("localhost", "NORTHWIND", "sa", "dx", MsSqlAuthorizationType.SqlServer))
SaveConnection(defaultConnection.Name, defaultConnection, True)

Reporting_how-to-provide-aspxreportdesigner-with-the-sqldatasource-objectdatasource-t271722/VB/WebApplication1/Default.aspx.vb#L17

Dim connectionParameters As New MsSqlConnectionParameters(".", "NWind", Nothing, Nothing, MsSqlAuthorizationType.Windows)
Dim ds As New DevExpress.DataAccess.Sql.SqlDataSource(connectionParameters)

how-to-display-the-total-value-above-each-pie-chart-t543185/VB/ASPxDashboard/Default.aspx.vb#L22

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