SQL Cluster Gateway Info Lost on Node Move or Failure Simulation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Cluster Gateway Info Lost on Node Move or...

SQL Cluster Gateway Info Lost on Node Move or Failure Simulation

Rate Topic

Display Mode

Topic Options

Author

Message

IamZilog

Posted Tuesday, February 19, 2013 12:03 PM

Forum 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

SQL Pizza

Posted Wednesday, February 20, 2013 5:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

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

IamZilog

Posted Thursday, February 21, 2013 9:09 AM

Forum 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

Daveghowes

Posted Thursday, May 02, 2013 1:40 PM

Forum 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

« Prev Topic | Next Topic »

Permissions