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