Changing port numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zach_john - 23 Jun 2005 18:22 GMT

On an active/active cluster what is the proper way of changing the port # on
the named instance after an install is complete and in use.

Reply to this Message

Geoff N. Hiten - 23 Jun 2005 18:41 GMT

Use the Server Network Utility to assign a new port number. The utility is
not cluster-aware so make the changes on all nodes in the cluster
individually. SQL server requires a service stop-start to change port
numbers.

Geoff N, Hiten
Microsoft SQL Server MVP

> On an active/active cluster what is the proper way of changing the port #
> on
> the named instance after an install is complete and in use.

Reply to this Message

zach_john - 23 Jun 2005 18:49 GMT

Thanks Geoff - just wanted to hear that confirmation.

Cheers,
Zach

> Use the Server Network Utility to assign a new port number. The utility is
> not cluster-aware so make the changes on all nodes in the cluster
[quoted text clipped - 7 lines]
> > on
> > the named instance after an install is complete and in use.

Reply to this Message

Geoff N. Hiten - 23 Jun 2005 18:51 GMT

It's always easier to learn from someone else's mistakes. :)

GNH

> Thanks Geoff - just wanted to hear that confirmation.
>
[quoted text clipped - 14 lines]
>> > on
>> > the named instance after an install is complete and in use.

Reply to this Message