Share via


sys.service_broker_endpoints (Transact-SQL)

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.

NULL = Windows Authentication is being used.

encryption_algorithm

tinyint

Encryption algorithm, one of one of the following values:

Value

Description

Corresponding DDL option

0NONE Disabled

1RC4 {Required | Required algorithm RC4}

2AES Required Algorithm AES

3NONE, RC4{Supported | Supported Algorithm RC4}

4NONE, AESSupported Algorithm RC4

5RC4, AES Required Algorithm RC4 AES

6AES, RC4 Required Algorithm AES RC4

7NONE, RC4, AES Supported Algorithm RC4 AES

8NONE, AES, RC4 Supported Algorithm AES RC4

Not NULLABLE.

encryption_algorithm_desc

nvarchar(60)

Encryption algorithm description, one of the following values:

Value

Corresponding DDL option

NONE Disabled

RC4 {Required | Required Algorithm RC4}

AES Required Algorithm AES

NONE, RC4{Supported | Supported Algorithm RC4}

NONE, AESSupported Algorithm RC4

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.

See Also

Reference

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

Other Resources

Network Protocols, and TDS Endpoints

Help and Information

Getting SQL Server 2005 Assistance