Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have three SQL Server 2008 instances running on a cluster. SQLInstance1 is listening on default port 1433, SQLInstance2 is listening on port 39999 and SQLInstance3 is listening on port 49999. Can SQLInstance2 listen on port 39999 and 49999 when SQLInstance2 and SQLInstance3 are running on the same node of the Windows2008 cluster?

share|improve this question

closed as not a real question by Brent Pabst, rnxrx, Ward, Michael Hampton, HopelessN00b Oct 6 '12 at 23:04

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Huh? Are you asking if two instances can share the same port? –  pauska Oct 1 '12 at 19:51
    
Your question does not make any sense. Can you see about editing it to clean it up? Its unanswerable as is. –  Brent Pabst Oct 1 '12 at 20:23

1 Answer 1

up vote 2 down vote accepted

The answer is no. On the same server or on a node of a cluster, you cannot have two instances of SQL listen on the same port number. The first instance that starts up will bind to that port number, and once the other instance tries to start up with the same port number it will receive an 'bind to port' or 'tcp port already in use' error.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.