TCP listening ports and ENDPOINT ports behavior

Endpoint configuration seems to be creating some confusion.  I hope that this will clarify some of the behavior as it applies to TCP endpoints. With a default configuration of SQL Server, try the following: > select name, port, is_dynamic_port, state from sys.tcp_endpoints> goname                        port is_dynamic_port state————————— —- ————— —–Dedicated Admin Connection     0               1     0TSQL Default…