Using the SQLCMD in SQL 2005 Server - SQL Server Network Connections
(Page 3 of 5 )
This opens up the SQL Server Configuration Manager as shown. This screen shows the various SQL Server 2005 services, the SQL 2005 Network Configuration and the SQL 2005 Client Configuration in a tree view. You may expand each of these to view the constituent parts for the nodes.
In this picture the SQL Server 2005 Network configuration has been expanded to show the various protocols that are enabled. One of them is the TCP protocol. Right click the TCP protocol in the list view (right pane) and look at its properties. It opens as shown in the window that is superposed with the title TCP/IP Properties with the default tab, Protocol in view. Here you can enable and disable the protocol and make other desired changes.
Clicking on the tab labeled IP Addresses opens up the window shown in the next picture. You see here that the TCP Dynamic Ports is 1037. With the port configured to use dynamic ports, when the instance of SQL Server starts up it takes an available end point for the port given by the operating system. The SQL Server Browser connects the incoming client to that port.
Next: SQL Client Connections >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
