Deploying Virtual Connect Enterprise Manageron Microsoft Cluster Service

18
a) Run SQL Server Configuration Manager
b) Expand SQL Server 2005 Network Configuration in the left panel
c) Select Protocols for InstanceName in the left panel, where InstanceName is a
placeholder for the named instance of SQL Server 2005
d) Double-click TCP/IP in the right panel
e) In the Protocol tab, note the value of the Listen All item
f) In the IP Addresses tab:
o If the value of Listen All is yes, the TCP/IP port number for this instance of SQL
Server 2005 is the value of the TCP Dynamic Ports item under IPAll
o If the value of Listen All is no, the TCP/IP port number for this instance of SQL
Server 2005 is the value of the TCP Dynamic Ports item for a specific IP address
Refer to the article “How to connect to a named instance of SQL Server 2005 or SQL Server
2000 by using the client tools in the earlier version of SQL Server” at
http://support.microsoft.com (search for “How to connect to a named instance of SQL Server
2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server”), or
the article “How to configure an instance of SQL Server to listen on a specific TCP port or a
dynamic port” at http://support.microsoft.com (search for “How to configure an instance of
SQL Server to listen on a specific TCP port or a dynamic port”) for more information on how to
determine the port where the SQL Server instance is listening.