sys.database_mirroring_endpoints (Transact-SQL)

Artykuł
02/13/2015

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

[!UWAGA]

The database mirroring endpoint supports both sessions between database mirroring partners and with witnesses and sessions between the primary replica of a AlwaysOn 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 [!UWAGA] This value is relevant only for database mirroring.
role_desc	nvarchar(60)	Description of mirroring role, one of: NONE PARTNER WITNESS ALL [!UWAGA] 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

[!UWAGA]

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 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 has been granted some permission. For more information, see Metadata Visibility Configuration.