Table of Contents

Class EndpointsSchema.DatabaseMirroringEndpoint

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.database_mirroring_endpoints (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Contains one row for the database mirroring endpoint of an instance of SQL Server.

note


The database mirroring endpoint supports both sessions between database mirroring partners and with witnesses and sessions between the primary replica of a Always On availability group and its secondary replicas.


See sys.database_mirroring_endpoints.

[Table(Schema = "sys", Name = "database_mirroring_endpoints", IsView = true)]
public class EndpointsSchema.DatabaseMirroringEndpoint
Inheritance
EndpointsSchema.DatabaseMirroringEndpoint
Extension Methods

Properties

CertificateID

ID of certificate used for authentication, if any.

0 = Windows Authentication is being used.

[Column("certificate_id")]
[NotNull]
public int CertificateID { get; set; }

Property Value

int

ConnectionAuth

The type of connection authentication required for connections to this endpoint, one of:

1 - NTLM

2 - KERBEROS

3 - NEGOTIATE

4 - CERTIFICATE

5 - NTLM, CERTIFICATE

6 - KERBEROS, CERTIFICATE

7 - NEGOTIATE, CERTIFICATE

8 - CERTIFICATE, NTLM

9 - CERTIFICATE, KERBEROS

10 - CERTIFICATE, NEGOTIATE

[Column("connection_auth")]
[NotNull]
public byte ConnectionAuth { get; set; }

Property Value

byte

ConnectionAuthDesc

Description of the type of authentication required for connections to this endpoint, one of:

NTLM

KERBEROS

NEGOTIATE

CERTIFICATE

NTLM, CERTIFICATE

KERBEROS, CERTIFICATE

NEGOTIATE, CERTIFICATE

CERTIFICATE, NTLM

CERTIFICATE, KERBEROS

CERTIFICATE, NEGOTIATE

[Column("connection_auth_desc")]
[Nullable]
public object? ConnectionAuthDesc { get; set; }

Property Value

object

EncryptionAlgorithm

Encryption algorithm, one of:

0 - NONE

1 - RC4

2 - AES

3 - NONE, RC4

4 - NONE, AES

5 - RC4, AES

6 - AES, RC4

7 - NONE, RC4, AES

8 - NONE, AES, RC4

[Column("encryption_algorithm")]
[NotNull]
public byte EncryptionAlgorithm { get; set; }

Property Value

byte

EncryptionAlgorithmDesc

Description of the encryption algorithm, one of:

NONE

RC4

AES

NONE, RC4

NONE, AES

RC4, AES

AES, RC4

NONE, RC4, AES

NONE, AES, RC4

[Column("encryption_algorithm_desc")]
[Nullable]
public string? EncryptionAlgorithmDesc { get; set; }

Property Value

string

EndpointID

ID of the endpoint. Is unique within the server. An endpoint with an ID less then 65536 is a system endpoint. Is not nullable.

[Column("endpoint_id")]
[NotNull]
public int EndpointID { get; set; }

Property Value

int

IsAdminEndpoint

Indicates whether the endpoint is for administrative use.

0 = Nonadministrative endpoint.

1 = Endpoint is an administrative endpoint.

Is not nullable.

[Column("is_admin_endpoint")]
[NotNull]
public bool IsAdminEndpoint { get; set; }

Property Value

bool

IsEncryptionEnabled

1 means that encryption is enabled.

0 means that encryption is disabled.

[Column("is_encryption_enabled")]
[NotNull]
public bool IsEncryptionEnabled { get; set; }

Property Value

bool

Name

Name of the endpoint. Is unique within the server. Is not nullable.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

PrincipalID

ID of the server principal that created and owns this endpoint. Is nullable.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?

Protocol

Endpoint protocol.

1 = HTTP

2 = TCP

3 = Name pipes

4 = Shared memory

5 = Virtual Interface Adapter (VIA)

Is not nullable.

[Column("protocol")]
[NotNull]
public byte Protocol { get; set; }

Property Value

byte

ProtocolDesc

Description of the endpoint protocol. NULLABLE. One of the following values:

HTTP

TCP

NAMED_PIPES

SHARED_MEMORY

VIA Note: The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

[Column("protocol_desc")]
[Nullable]
public string? ProtocolDesc { get; set; }

Property Value

string

Role

Mirroring role, one of:

0 = None

1 = Partner

2 = Witness

3 = All

Note: This value is relevant only for database mirroring.

[Column("role")]
[Nullable]
public byte? Role { get; set; }

Property Value

byte?

RoleDesc

Description of mirroring role, one of:

NONE

PARTNER

WITNESS

ALL

Note: This value is relevant only for database mirroring.

[Column("role_desc")]
[Nullable]
public string? RoleDesc { get; set; }

Property Value

string

State

The endpoint state.

0 = STARTED, listening and processing requests.

1 = STOPPED, listening, but not processing requests.

2 = DISABLED, not listening.

The default state is 1. Is nullable.

[Column("state")]
[Nullable]
public byte? State { get; set; }

Property Value

byte?

StateDesc

Description of the endpoint state.

STARTED = Listening and processing requests.

STOPPED = Listening, but not processing requests.

DISABLED = Not listening.

The default state is STOPPED.

Is nullable.

[Column("state_desc")]
[Nullable]
public string? StateDesc { get; set; }

Property Value

string

TypeColumn

Endpoint payload type.

1 = SOAP

2 = TSQL

3 = SERVICE_BROKER

4 = DATABASE_MIRRORING

Is not nullable.

[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }

Property Value

byte

TypeDesc

Description of the endpoint payload type. Is nullable. One of the following values:

SOAP

TSQL

SERVICE_BROKER

DATABASE_MIRRORING

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string