Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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