Using the default port for the instances on a cluster node

Question

Using the default port for the instances on a cluster node

SQLBuddy123

One Orange Chip

Points: 28294
More actions
June 2, 2009 at 8:11 am

#201002

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

Yes, each instance in the cluster can use the default port.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

Hi Jeffrey,

Thank you very much for your reply.

Could you please clarify me one more thing?

But is using the default port 1433 for each of the instances on a Single Cluster Node recommended practice ? Does it have any problems or issues ?

Or Using different non-stand port numbers (Non Dynamic or dedicated) for different instances on the single cluster node is recommended?

Thank you,

Yours,

SQLBuddy

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

I don't know that I have seen a specific recommendation. Unless I had a definitive reason for changing the default port - I would not change it.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

Hi Jeffrey,

Thank you very much for all your guidance. I really appreciate your help.

Yours

SQLBuddy

mtassin SSC-Insane Points: 23099 More actions · Answer 5

Running them all on 1433 is fine.

The reason it doesn't default to that is that when you install the instances on a cluster they're named instances and by default named instances (as opposed to a default sql install) get dynamically assigned SQL ports.

This can be a problem when one clustered instance is running the database for ISA logging. ISA positively hates dynamically allocated ports. I had to set one of my nodes to run on 1433, because even with the latest Service Packs it refused to connect to SQL on anything but port 1433. Even when I specified in its config to use a different port.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

Hi Mtassin,

Thank you very much for your reply. I really appreciate your detailed answer.

Yours

SQLBuddy