Edit

sys.service_broker_endpoints (Transact-SQL)

  • Article

Applies to: SQL Server

This catalog view contains one row for the Service Broker endpoint. For every row in this view, there is a corresponding row with the same endpoint_id in the sys.tcp_endpoints view that contains the TCP configuration metadata. TCP is the only allowed protocol for Service Broker.

Column name Data type Description
<inherited columns> -- Inherits columns from sys.endpoints (Transact-SQL).
is_message_forwarding_enabled bit Does endpoint support message forwarding. This is initially set to 0 (disabled). Not NULLABLE.
message_forwarding_size int The maximum number of megabytes of tempdb space allowed to be used for messages being forwarded. This is initially set to 10. Not NULLABLE.
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

Not NULLABLE.
connection_auth_desc nvarchar(60) Description of the type of connection 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

NULLABLE.
certificate_id int ID of certificate used for authentication, if any.

0 = Windows Authentication is being used.
encryption_algorithm tinyint Encryption algorithm. The following are the possible values with their descriptions and corresponding DDL options.

0 : NONE. Corresponding DDL option: Disabled.

1 : RC4. Corresponding DDL option: {Required | Required algorithm RC4}.

2 : AES. Corresponding DDL option: Required Algorithm AES.

3 : NONE, RC4. Corresponding DDL option: {Supported | Supported Algorithm RC4}.

4 : NONE, AES. Corresponding DDL option: Supported Algorithm AES.

5 : RC4, AES. Corresponding DDL option: Required Algorithm RC4 AES.

6 : AES, RC4. Corresponding DDL option: Required Algorithm AES RC4.

7 : NONE, RC4, AES. Corresponding DDL option: Supported Algorithm RC4 AES.

8 : NONE, AES, RC4. Corresponding DDL option: Supported Algorithm AES RC4.

Not NULLABLE.
encryption_algorithm_desc nvarchar(60) Encryption algorithm description. The possible values and their corresponding DDL options are listed below:

NONE : Disabled

RC4 : {Required | Required Algorithm RC4}

AES : Required Algorithm AES

NONE, RC4 : {Supported | Supported Algorithm RC4}

NONE, AES : Supported Algorithm AES

RC4, AES : Required Algorithm RC4 AES

AES, RC4 : Required Algorithm AES RC4

NONE, RC4, AES : Supported Algorithm RC4 AES

NONE, AES, RC4 : Supported Algorithm AES RC4

NULLABLE.

Remarks

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 (11.x) and later versions, 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 was granted some permission. For more information, see Metadata Visibility Configuration.

See Also

ALTER ENDPOINT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)