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.
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 |
Remarks
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 (11.x) and higher, material encrypted using RC4 or RC4_128 can be decrypted in any compatibility level.
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
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