| title | sys.database_mirroring_endpoints (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.prod_service | database-engine | ||||
| ms.service | |||||
| ms.component | system-catalog-views | ||||
| ms.reviewer | |||||
| ms.suite | sql | ||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | f2285199-97ad-473c-a52d-270044dd862b | ||||
| caps.latest.revision | 49 | ||||
| author | stevestein | ||||
| ms.author | sstein | ||||
| manager | craigg | ||||
| ms.workload | On Demand |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Contains one row for the database mirroring endpoint of an instance of [!INCLUDEssNoVersion].
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 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 Note: This value is relevant only for database mirroring. |
| role_desc | nvarchar(60) | Description of mirroring role, one of: NONE PARTNER WITNESS ALL Note: This value is relevant only for database mirroring. |
| 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 |
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 [!INCLUDEssSQL11] and higher, material encrypted using RC4 or RC4_128 can be decrypted in any compatibility level.
[!INCLUDEssCatViewPerm] 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