I want to understand the IP Addresses tab of the TCP/IP Properties in SQL Server Configuration Manager. The following settings are from the default named instance of SQL Server 2005 Express (computernameSQLEXPRESS) on a Windows XP SP2 machine with IP Address 192.168.1.151. IP1 has the following settings: Active: Yes Enabled: No IP Address: 192.168.1.151 TCP Dynamic Ports: 0 TCP Port: 1433 IP2 has the following settings: Active: Yes Enabled: No IP Address: 127.0.0.1 TCP Dynamic Ports: 0 TCP Port: IPAll TCP Dynamic Ports: 1121 TCP Port: Is the instance using Dynamic Port or Static Port? Normally, I will see blank for TCP Port when TCP Dynamic Ports is 0 in IP1 but in this case, TCP Port has 1433. My guess is that the instance is using Dynamic Port and the port is 1121.