Connection handshake is complete and is online (ready) for message exchange.

Connection is in error.

peer_certificate_id

int

The local object ID of the certificate used by the remote instance for authentication. The owner of this certificate must have CONNECT permissions to the database mirroring endpoint.

encryption_algorithm

smallint

Encryption algorithm that is used for this connection. NULLABLE. Possible values:

Value

Description

Corresponding DDL option

0

NONE

Disabled

1

RC4

{Required | Required algorithm RC4}

2

AES

Required algorithm AES

3

NONE, RC4

{Supported | Supported algorithm RC4}

4

NONE, AES

Supported algorithm RC4

5

RC4, AES

Required algorithm RC4 AES

6

AES, RC4

Required Algorithm AES RC4

7

NONE, RC4, AES

Supported Algorithm RC4 AES

8

NONE, AES, RC4

Supported algorithm AES RC4

Note

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.