RE: ensure port is free upon failover

Tech-Archive recommends: Speed Up your PC by fixing your registry

You can create alias for Sql server instance name on client PC.
for more information visit this link
http://msdn.microsoft.com/en-us/library/ms190445.aspx

But one thing which is important is to note that, you have to make alias on
every client PC which you wanted to use.

Manpreet Singh
http://crazysql.co.nr
http://crazysql.wordpress.com
MCITP – DB Admin, DB Dev SQL Server 2005
MCTS – MOSS 2007, SQL server 2005



"Linchi Shea" wrote:

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: Unable to print to networked printer - get access denied messa
    ... Check the permissions on the server assuming the client has a true RPC ... How is the Standard TCP/IP port configured for the device? ...
    (microsoft.public.windowsxp.print_fax)
  • Re: interfaces lo:1 lo:2 lo:3? (for remote ssh tunnels)
    ... That's the problem tunneling (port forwarding) solves. ... >>can't get past the client firewall. ... > I don't understand why the server would be making the ... server initiates another connection to the client -- in this ...
    (Debian-User)
  • Re: Remote Connection Issue
    ... through port number 3389 and a workstation on the LAN through port number ... I understand that you want to allow a LAN client ... and you have configured server publishing rule ... > By default Terminal Server and Windows 2000 Terminal Services uses TCP ...
    (microsoft.public.windows.server.sbs)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)