Using the default port for the instances on a cluster node | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Using the default port for the instances on a cluster node

Hi,
We have a cluster node with multiple SQL Server 2005 instances. Since these instances have different IP addresses can we use the same default TCP/IP port 1433 for all of these instances or should we use different non standard port numbers for these instances?
Could any one please help me with this issue?
Thank you,
Yours,
SQLBuddy

You can’t use the same defaultTCP/IP port 1433 for all of these instances on the same server.
for same port# , you get error:
TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Only one usage of each socket address (protocol/network address/port) is normally permitted.
you can:
  • Use different Static port numbers for these instances, and connection string for server is IP,port#
example; 192.168.1.39,5000
  • Use dynamic port (sql browser should be runnung), i don’t recommend using dynamic port.
  • You can create alias on client machines for the server,port#.

Hi Hassan,
Thank you very much for the reply. I really appreciate your quick help.
Yours
SQLBuddy.

This is not quite correct regarding the port numbers. You can only have one default instance in a cluster and this is due to the name of the SQL Service – MSSQLSERVER. The named instances in the cluster can have the same port (1433, even) if desired, because the ports are allocated per IP address, not by machine. This is because each instance is its own cluster resource with its own IP address.
You can’t use the same defaultTCP/IP port 1433 for all of these instances on the same server.
for same port# , you get error:
TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Only one usage of each socket address (protocol/network address/port) is normally permitted.
you can:
  • Use different Static port numbers for these instances, and connection string for server is IP,port#
example; 192.168.1.39,5000
  • Use dynamic port (sql browser should be runnung), i don’t recommend using dynamic port.
  • You can create alias on client machines for the server,port#.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |