sys.database_mirroring_endpoints (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

System_CAPS_ICON_note.jpg 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.

Column nameData typeDescription
<inherited columns>Inherits columns from sys.endpoints (for more information, see sys.endpoints (Transact-SQL)).
roletinyintMirroring role, one of:

 0 = None

 1 = Partner

 2 = Witness

 3 = All

Note: This value is relevant only for database mirroring.
role_descnvarchar(60)Description of mirroring role, one of:

 NONE

 PARTNER

 WITNESS

 ALL

Note: This value is relevant only for database mirroring.
is_encryption_enabledbit1 means that encryption is enabled.

 0 means that encryption is disabled.
connection_authtinyintThe 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_descNvarchar (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_idintID of certificate used for authentication, if any.

0 = Windows Authentication is being used.
encryption_algorithmtinyintEncryption 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_descnvarchar(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
System_CAPS_ICON_note.jpg Note


The RC4 algorithm is only supported for backward compatibility. New material can only be encrypted using RC4 or RC4_128 when the database is in compatibility level 90 or 100. (Not recommended.) Use a newer algorithm such as one of the AES algorithms instead. In SQL Server 2012 and higher, material encrypted using RC4 or RC4_128 can be decrypted in any compatibility level.

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.

Specify the Endpoint URL When Adding or Modifying an Availability Replica (SQL Server)
sys.availability_replicas (Transact-SQL)
sys.database_mirroring (Transact-SQL)
sys.database_mirroring_witnesses (Transact-SQL)
The Database Mirroring Endpoint (SQL Server)
Querying the SQL Server System Catalog FAQ

Community Additions

ADD
Show: