RE: ensure port is free upon failover

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

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

"Martin" wrote:

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.


.

Relevant Pages

  • RE: pen-test on a windows 2003 server box whit MS-SQL and Terminal Services
    ... laptop/pen-test system in as a Man-in-the-Middle between the SQL server ... > MS-SQL and Terminal Services ... > Have you done UDP port scans? ... obtaining the SQL version; since the OS is Win3k the SQL ...
    (Pen-Test)
  • Re: client cant connect when instance on one particular node
    ... Best practice is to specify a specific port and then code the client to ... SQL 2000 SP4 for SQL version. ... Then server guys evicted ... cluster configuration. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: RealVNC
    ... Default listening port for RealVNC server that runs on the machine on which ... Then there is default Java listening port on port 5800 on the client machine ...
    (microsoft.public.windows.server.sbs)
  • Re: Remote ODBC connection to SQL Server 2005 Exp.
    ... Try scanning your Win2K server from the Internet to see if the port 1433 is ... I am using Access 2000 as the front end with SQL 2005 Exp. ... There is a Netgear RP 114 router for the office network. ...
    (microsoft.public.access.externaldata)