February 23, 2012 at 12:23 pm
I figured out the issue...Node C was newly built and the firewall was enabled...I disabled the firewall and am able to connect now from my laptop to sql instances after failover.
Thanks for all you help elliot.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 23, 2012 at 12:51 pm
I hadn't read the last mesage and was thinking firewall.. Good deal, so it works as expected. I do say that the mode you are running in is ultra dependent on the quorum ALWAYS being available with no problems.. That is a bit much for me personally but YMMV..
Good Luck.
CEWII
February 24, 2012 at 7:17 am
One last thing is.. is it mandatory to have 2 nic cards for each individual node when implementing sql clustering in sql server 2008 R2 EE X64bit on windows server 2008 r2 EE X64bit?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
February 24, 2012 at 7:45 am
It is not mandatory for clustering, just highly recommended. I have a dev cluster with a single nic, not ideal but a limitation that I don't have any choices to resolve. So yes you can do it with one, but if possible do 2.
CEWII
March 2, 2012 at 8:08 am
For my testing I have destroyed my entire cluster that I built and I am rebuilding the 3 node clustering with two network cards and when I am trying to install sql server for a new cluster I am getting the following error:
The IP Address is already in use. Pick another IP address to continue.
No matter what IP address I specify (in range) I still get this error. Has any one seen with this error before?
The one thing that I did not do after evicting the nodes and destroying a clustering is unregistering the servers (3 nodes) from the dns. since I am rebuilding the cluster on the same servers should I unregister them first to get rid of this error and reregister the servers back in the DNS?
Please advice.
Thanks a ton.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 2, 2012 at 8:11 am
Are you rebuilding them as the same names? If so I would think it wouldn't require an un-register.
For different names, I'm going with yeah, you should..
CEWII
March 2, 2012 at 8:23 am
I am using the same names. The only difference is I added a new nic card to each server.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 2, 2012 at 8:38 am
Hm, odd, I'dd drop the registration then and try again.
CEWII
March 2, 2012 at 8:42 am
yeah.. I just deleted them and added back to the DNS...now when i do an nslookup from each server to a different one I see both the IP addresses for each server..I am installing sql now..hope it goes well
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 2, 2012 at 9:25 am
No It doesnt work for some reason...I still got this error:
SQL Server Setup has encountered the following error:
The IP Address '' is already in use. To continue, specify a different IP address.
Error code 0x84B40000.
The IP on which it errors out is one of the IP Addresses that I provide at the "Specify the network settings for this failover cluster:" screen.
eg:
ClusterNetwork1 192.168.1.20
ClusterNetwork2 192.168.2.20
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 2, 2012 at 9:28 am
If you ping those addresses does anything answer?
CEWII
March 2, 2012 at 9:35 am
No
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 2, 2012 at 9:40 am
Ok...I was able to install SQL successfully with just one IP (I unchecked the Network Cluster2) instead of giving it 2 IP's...I dont understand why it errors out when I use the second IP for the second NIC.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
March 2, 2012 at 10:56 am
Hold up..
How many NICs do you have in these servers? 2 or 3?
One of the NICs should be for heartbeat and its subnet should be outside the normal subnet you use. Such as 192.168.x.y.
CEWII
March 2, 2012 at 12:13 pm
Server Manager-->Diagnostics-->Device Manager-->Network Adapters-->2 for each server
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Viewing 15 posts - 31 through 45 (of 56 total)
You must be logged in to reply to this topic. Login to reply