Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mattkoo
Starting Member
2 Posts |
 Posted - 2004-04-26 : 15:20:45
|
| Hello,We have a 2 node active/passive SQL cluster setup and recently have been having really strange intermittent problems with the public side interface on the passive node.Around 4-5 times a day the passive node will complain with a warning that it lost communication with the public interface of the active node followed by a few more warnings about the public side interface going down. The active node shows these occurrances in it's event log as losing public network connectivity to the passive node.I don't think this is an issue with the network card or cabling. I was logged on the passive node during one of its public side interface outages and it was still able to ping the active node by name and the virtual SQL server but it was not able to ping the cluster name. All 3 are pointing to the same public side interface on the active node.Any advice on what is causing these problems and the solution would be greatly appreciated.Thanks in advance,Matt. |
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2004-04-26 : 17:57:25
|
| Did you try to use another network Card to use for private cluster comunication?I always set the service DNS CLIENT to manaul, this may help you. |
 |
|
|
Mattkoo
Starting Member
2 Posts |
Posted - 2004-04-26 : 18:04:33
|
quote:
Originally posted by gercr
Did you try to use another network Card to use for private cluster comunication?I always set the service DNS CLIENT to manaul, this may help you.
Hi gercr,Thanks for your suggestion. We have 2 NICs in each node, 1 for the public network and 1 for the private network. The problems thus far have been with the public network interface on the passive node.We have a change request in to replace the public side NIC on our passive node tonight.I'm not sure what setting the DNS Client service to manual will do for me? Is DNS a possible cause of our problems?Thanks,Matt. |
|
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2004-05-11 : 10:30:39
|
| I am experiencing the same problem on my active/active cluster.Did you get any resolution to the problem. So far I have not found a solution for this.Lance Harra |
|
|
|
|
|
|
SQL Cluster, passive node losing public interface