ensure port is free upon failover

Discussion in 'microsoft.public.sqlserver.clustering' started by Martin, May 28, 2009.

  1. Martin

    Martin Guest

    Hi,

    I have just installed a two node active/active cluster.
    everything is fine, however I have a question about the ports.

    a first instance is installed with "box A" being the preferred node for
    "instance A"
    the second instance is installed with "box B" being the preferred node for
    "instance B"
    instance A is listening on TCP port 60615.
    so I've made an exception in the firewall on "box A" for port 60615.

    however in a failover situation where instance A fails-over to box B the
    instance will still be listening on port 60615.

    how can I be sure that any future software installed on box b will not take
    port 60615.

    also, when I connect to the instance using SSMS i connect using
    "sqlCluserName\InstanceName,PortNumber"
    how can I connect using just "sqlCluserName\InstanceName" - I guess that sql
    server must have a way of determining the port that an instance of sq server
    is listening on.

    many thanks in advance

    martin.
     
    Martin, May 28, 2009
    #1
    1. Advertisements

  2. Each SQL Instance is actually on its own IP address. Therefore, the port
    numbers can intersect without collision since the IP addresses are
    different.
     
    Geoff N. Hiten, May 28, 2009
    #2
    1. Advertisements

  3. Martin

    Linchi Shea Guest

    also, when I connect to the instance using SSMS i connect using
    That is what SQL Browser is for. When you connect with
    sqlCluserName\InstanceName, the client will talk to SQL Browser over UDP and
    obtain the necessary TCP port number.

    Linchi
     
    Linchi Shea, Jun 2, 2009
    #3
  4. Manpreet Singh, Jun 4, 2009
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.