sys.tcp_endpoints
compatibilityDescription
Syntax
WHERE des.session_id = @@SPIDRemarks
Returns one row for each TCP endpoint in the system. The endpoints that are described by
provide an object to grant and revoke the connection privilege. The
information that is displayed regarding ports and IP addresses isn’t used to configure the
protocols and might not match the actual protocol configuration. To view and configure
protocols, use SQL Server Configuration Manager.
Description
Inherits columns from
sys.endpoints
The port number that the endpoint is listening on. Not nullable.
1 = Port number was dynamically assigned.
Not nullable.
Listener IP address as specified by the LISTENER_IP clause.
Execute the following query to gather information about the endpoints and connections.
Endpoints without current connections or without TCP connections will appear with NULL
values. Add the
to return information about the
current connection.
Expand table
When a route specifies
next_hop_address
, the network address is
determined based on the network address in the name of the service. A route that specifies
can specify a service name or broker instance.
next_hop_address
is the principal server for a database mirror, you must also specify
the MIRROR_ADDRESS for the mirror server. Otherwise, this route does not automatically
failover to the mirror server.
MIRROR_ADDRESS
next_hop_mirror_address
Specifies the network address for the mirror server of a mirrored pair whose principal server is
next_hop_address
next_hop_mirror_address
specifies a TCP/IP address in the
following format:
netbios_name
port_number
The specified
port_number
must match the port number for the Service Broker endpoint of an
instance of SQL Server at the specified computer. This can be obtained by running the
following query in the selected database:
When the MIRROR_ADDRESS is specified, the route must specify the SERVICE_NAME clause
and the BROKER_INSTANCE clause. A route that specifies
next_hop_address
might not specify a mirror address.
This option is not available in a contained database.
This option is not available in a contained database.
When the service is hosted in a mirrored database, you must also specify the
MIRROR_ADDRESS for the other instance that hosts a mirrored database. Otherwise, this route
does not fail over to the mirror.
When a route specifies
next_hop_address
, the message is delivered to a service
within the current instance of SQL Server.
When a route specifies
next_hop_address
, the network address is
determined based on the network address in the name of the service. A route that specifies
might not specify a service name or broker instance.
MIRROR_ADDRESS
next_hop_mirror_address
Specifies the network address for a mirrored database with one mirrored database hosted at
next_hop_address
next_hop_mirror_address
specifies a TCP/IP address in the following
netbios_name
port_number
The specified
port_number
must match the port number for the Service Broker endpoint of an
instance of SQL Server at the specified computer. This can be obtained by running the
following query in the selected database:
When the MIRROR_ADDRESS is specified, the route must specify the SERVICE_NAME clause
and the BROKER_INSTANCE clause. A route that specifies
next_hop_address
might not specify a mirror address.