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

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 an 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
Inherited Members
Extension Methods

Properties

CertificateID

certificate_id NOT NULL int

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

connection_auth NOT NULL tinyint

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

connection_auth_desc NULL Nvarchar (60)

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 NOT NULL tinyint

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

encryption_algorithm_desc NULL nvarchar(60)

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

endpoint_id NOT NULL int

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

is_admin_endpoint NOT NULL bit

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

is_encryption_enabled NOT NULL bit

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 NOT NULL sysname

Name of the endpoint. Is unique within the server. Is not nullable. 
[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

PrincipalID

principal_id NULL int

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

protocol NOT NULL tinyint

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

protocol_desc NULL nvarchar(60)

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 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

role NULL tinyint

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

role_desc NULL nvarchar(60)

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

state NULL tinyint

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

state_desc NULL nvarchar(60)

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

Type

type NOT NULL tinyint

Endpoint payload type.

1 = SOAP

2 = TSQL

3 = SERVICE_BROKER

4 = DATABASE_MIRRORING

Is not nullable. 
[Column("type")]
[NotNull]
public byte Type { get; set; }

Property Value

byte

TypeDesc

type_desc NULL nvarchar(60)

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