Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Cluster Gateway Info Lost on Node Move or Failure Simulation Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2013 12:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:46 AM
Points: 2, Visits: 9
Hello All,

First time poster so if this has been asked, please forgive. I have searched the forums but didn't find what I was looking for.

I have a 2 server node SQL Cluster, running on identical Dell hardware, in the same datacenter, in the same subnet, both running 2008R2 OS and SQL 2008R2. In addition, all network configurations on the NICs are statically entered on the servers and not being pulled via DHCP. We are using (2) NICs per server. One for the network and one for the cluster heartbeat.

When the servers are rebooted and the SQL failover process runs its natural course, we do not lose any network configuration info on the networked NICs. All network info remains on both servers.

If we log into either server and manually do a failover, either by "Move this service or application to another node" or "Simulate failure of this resource", the server that was the ACTIVE node loses its Gateway IP Info as soon as the failover completes. All other network info remains unchanged and intact.

It doesn't matter which server we are on, and which server we are failing over to. The server with the ACTIVE node at the time of the failover loses its Gateway IP info but nothing else.

This does not happen when failovers happen on their own due to server reboots (like patch days).

All hardware and network configurations, with the exception of specific IP Address configs, are all the same.

Any ideas?

Thanks in advance for your time.

Dan
Post #1421800
Posted Wednesday, February 20, 2013 5:40 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 1:52 AM
Points: 120, Visits: 368
You mean the TCP/IP-Gateway, or the Cluster IP?

Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1422037
Posted Thursday, February 21, 2013 9:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:46 AM
Points: 2, Visits: 9
The TCP/IP-Gateway on the server's NIC.

Before the Node failover, under TCP/IPv4 properties, as well as ipconfig/all, the server shows:

(These are statically assigned and not pushed out via DHCP.)

Server IP Address
Subnet Mask
Default Gateway
Preferred DNS
Alternate DNS

After the Node failover, under TCP/IPv4 properties, as well as ipconfig/all, the server shows:

Server IP Address
Subnet Mask
No Default Gateway
Preferred DNS
Alternate DNS

This only happens to the server with the ACTIVE node at the time of the failover.

Thanks.

Dan
Post #1422659
Posted Thursday, May 2, 2013 1:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:06 AM
Points: 1, Visits: 1
Hi

Did you ever fix this, I have the exact same issue, everything is the same except I am on HP servers.

Thanks
Post #1448965
Posted Saturday, May 10, 2014 3:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 10, 2014 3:36 AM
Points: 1, Visits: 0
Hi,

I do facing the same problem but running on vmware . Anyone got solution ?

Regard
Wvoong
Post #1569504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse