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:
|
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:
|
certificate_id |
int |
ID of certificate used for authentication, if any. NULL = 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 |
See Also
Reference
sys.database_mirroring (Transact-SQL)
sys.database_mirroring_witnesses (Transact-SQL)
Other Resources
Database Mirroring Endpoint
Querying the SQL Server System Catalog FAQ