Thursday, February 16, 2012

clustering - cannot ping sql virtual name

I have a two node cluster. Node 1 has the SQL instance running on it and
Node 2 has the cluster group and msdtc running on it. I can ping the SQL
virtual name and access SQL successfully. If I move the SQL group to Node 2,
then I can no longer ping the virtual name or access the database. Any ideas?
When a cluster moves from one node to another the uplink (probably a router)
needs to react appropriately. The uplink needs to update it's ARP table
(http://www.webopedia.com/TERM/A/ARP.html). The new controlling node will
also send out a gratuitous ARP so that whoever is listening will update
themselves. It appears that in your case the gratuitous ARP is falling on
deaf ears. Talk to your networking group and possibly sniff the wire during
a move.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"jay d" <jayd@.discussions.microsoft.com> wrote in message
news:52FAFC71-4801-457B-9FFF-E5742ACB3032@.microsoft.com...
>I have a two node cluster. Node 1 has the SQL instance running on it and
> Node 2 has the cluster group and msdtc running on it. I can ping the SQL
> virtual name and access SQL successfully. If I move the SQL group to Node
> 2,
> then I can no longer ping the virtual name or access the database. Any
> ideas?
>

No comments:

Post a Comment