sys.database_mirroring_endpoints (Transact-SQL)

Contains one row for the database mirroring endpoint of the server instance.

Column name

Data type

Description

<inherited columns>

Inherits columns from sys.endpoints (for more information, see sys.endpoints (Transact-SQL)).

role

tinyint

Mirroring role, one of:

0 = None

1 = Partner

2 = Witness

3 = All

role_desc

nvarchar(60)

Description of mirroring role, one of:

  • NONE

  • PARTNER

  • WITNESS

  • ALL

is_encryption_enabled

bit

1 means that encryption is enabled.

0 means that encryption is disabled.

connection_auth

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

connection_auth_desc

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

certificate_id

int

ID of certificate used for authentication, if any.

0 = Windows Authentication is being used.

encryption_algorithm

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

encryption_algorithm_desc

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

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.