Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Static port on named instance in a cluster. Expand / Collapse
Posted Monday, March 18, 2013 12:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 7, 2015 12:39 PM
Points: 5, Visits: 27
I have a two node SQL cluster (2008R2). Each node on the cluster hosts a named instance. I am having a problem upgrading my VMWare vCenter to 5.1. Here is an article I found about the issue and the resolution.

My question is can I make this change without screwing up my cluster? Will it have ill effect duing a failover event? If I can make this change what issues might I run into later since I have switched from dynamic to static ports? Can I make this change on only one named instand and not the other?
Post #1432307
Posted Monday, March 18, 2013 1:59 PM



Group: General Forum Members
Last Login: 2 days ago @ 1:35 PM
Points: 2,063, Visits: 3,384
It's been a while, but I changed instances to use a static port on a SQL Server 2008 cluster at my previous job. We had to use static ports due to the firewall between the web servers and the database servers blocking UDP packets (which SQL Browser uses). I don't recall any issues related to the change. We set all of our instances to use fixed ports, but I don't think you'd need to make both your instances static. I believe If the dynamic instance were to fail over, it should select a random port only from the ports available. I've never tried mixing the two though, so I can't say for sure.
Post #1432328
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse