Compartilhar via


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:

  • NONE
  • PARTNER
  • WITNESS
  • ALL

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.

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

Help and Information

Getting SQL Server 2005 Assistance