We are planning on setting a static port for SQL Server 2005/2008 failover clustering. Any guide on what port to choose/select for 4 nodes of each cluster?(Active/Active)
I am also thinking some applications need to know about the static port. What is the best way of knowing which application is setup to use default port from the SQL instance? In general, what is the best way of implementing port number change on sql server failover clustering?
SQL Server – How to Change Port Number
clusteringsql serversql-server-2005sql-server-2008
Related Question
- Sql-server – Active/active SQL Server Clustering in Installation Center (setup.exe)
- SQL Server Cluster Node Eviction Risks Without Uninstalling SQL Server Binaries
- Change Port Number for SQL Server 2012 Cluster
- SQL Server Cluster – Setting Up Multiple Nodes for High Availability
- Sql-server – Always On Failover Clustering vs Always On Availability Groups
- Sql-server – Automatic failover (Clustering/Always On AG)
Best Answer
The port number you select doesn't matter. Static port numbers should only be needed if you need to specify holes through a firewall which isn't on the local server. All SQL Server client drivers can convert the instance name to the TCP port number automatically using the SQL Server Browser.
The nice thing about using dynamic port numbers is that the TCP port will always be available. If you specify a static port number, there is a risk that something else will grab that port before SQL Starts up (I've seen this happen before) which will cause SQL to start without grabbing the port.