MsSqlConnectionParameters.TrustServerCertificate Property

Gets or sets a value that indicates whether the channel will be encrypted when certificate chain bypass is performed to validate trust.

Namespace: DevExpress.DataAccess.ConnectionParameters

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

public DefaultBoolean TrustServerCertificate { get; set; }

VB.NET

Public Property TrustServerCertificate As DefaultBoolean

Property Value

Type	Description
DefaultBoolean	A DefaultBoolean enumeration value that specifies whether the channel will be encrypted when certificate chain bypass is performed to validate trust.

Available values:

Name	Description	Return Value
True	The value is true.	0
False	The value is false.	1
Default	The value is specified by a global option or a higher-level object.	2

Remarks

This property corresponds to the “TrustServerCertificate” key within the connection string. When you set TrustServerCertificate to true, the transport layer uses SSL to encrypt the channel and bypass walking the certificate chain to validate trust.

If the property value is Default, the connection uses the option set by the provider (Microsoft.Data.SqlClient or System.Data.SqlClient).

The following code snippet shows how to configure connection parameters to establish connection to Microsoft SQL Server:

C#

using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
// ...
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(){
    ServerName = "localhost",
    DatabaseName = "Northwind",
    AuthorizationType = MsSqlAuthorizationType.Windows,
    TrustServerCertificate = DevExpress.Utils.DefaultBoolean.True,
    Encrypt = DevExpress.Utils.DefaultBoolean.True
};
SqlDataSource ds = new SqlDataSource();
ds.ConnectionName = "nwindConnection";
ds.ConnectionParameters = connectionParameters;

VB.NET

Imports DevExpress.DataAccess.ConnectionParameters
Imports DevExpress.DataAccess.Sql
' ...
Private connectionParameters As New MsSqlConnectionParameters() With {
    .ServerName = "localhost",
    .DatabaseName = "Northwind",
    .AuthorizationType = MsSqlAuthorizationType.Windows,
    .TrustServerCertificate = DevExpress.Utils.DefaultBoolean.True,
    .Encrypt = DevExpress.Utils.DefaultBoolean.True
}
Private ds As New SqlDataSource()
ds.ConnectionName = "nwindConnection"
ds.ConnectionParameters = connectionParameters

The resulting connection string looks as follow:

"XpoProvider=MSSqlServer;data source=localhost;integrated security=SSPI;initial catalog=Northwind;Encrypt=true;TrustServerCertificate=true"