March 18, 2013 at 12:38 pm
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. http://kb.vmware.com/kb/2039092
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?
March 18, 2013 at 1:59 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply