Udostępnij za pośrednictwem


sys.database_mirroring_endpoints (Transact-SQL)

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.

Zobacz także

Odwołanie

sys.availability_replicas (Transact-SQL)

sys.database_mirroring (Transact-SQL)

sys.database_mirroring_witnesses (Transact-SQL)

Koncepcje

Specify the Endpoint URL When Adding or Modifying an Availability Replica (SQL Server)

The Database Mirroring Endpoint (SQL Server)

Querying the SQL Server System Catalog FAQ