Internet Access on SQL Cluster

rbmacct
rbmacct used Ask the Experts™
on
I am building a MS Server 2008 R2 SQL Cluster and I have a few questions. The enviroment is built in a blade chassis with 2 nodes. Both nodes have 2 nic's to the LAN (1 active), 1 nic to the private network and 2 active nics to the iSCSI environment.

The cluster is working and failing over perfectly. It's even passing the validation with Microsoft.

My problem is that I can't get to the internet with either of these machines. I'm not sure why. The firewall at the gateway is not blocking this. It works about 1 out of 10 times. It's very slow and very odd. I have a feeling this all started after I created the cluster. Sometimes local network resources aren't available. However incoming connections work just time.

I'm thinking it has to do with routing within the NIC's and each server themselves. Below I have included a route print from both machines to see if there is anything in there that looks odd.


SQL-Node1

IPv4 Route Table
===========================================================================
Active Routes:
Network Destination        Netmask          Gateway       Interface  Metric
          0.0.0.0          0.0.0.0         10.1.1.1        10.1.1.86    266
          0.0.0.0          0.0.0.0    192.168.1.254     192.168.1.10    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.220    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.221    266
         10.1.1.0    255.255.255.0         On-link         10.1.1.86    266
        10.1.1.86  255.255.255.255         On-link         10.1.1.86    266
       10.1.1.255  255.255.255.255         On-link         10.1.1.86    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.221    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.220    266
      10.1.10.220  255.255.255.255         On-link       10.1.10.220    266
      10.1.10.221  255.255.255.255         On-link       10.1.10.221    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.221    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.220    266
        127.0.0.0        255.0.0.0         On-link         127.0.0.1    306
        127.0.0.1  255.255.255.255         On-link         127.0.0.1    306
  127.255.255.255  255.255.255.255         On-link         127.0.0.1    306
      169.254.0.0      255.255.0.0         On-link     169.254.1.252    261
    169.254.1.252  255.255.255.255         On-link     169.254.1.252    261
  169.254.255.255  255.255.255.255         On-link     169.254.1.252    261
      192.168.1.0    255.255.255.0         On-link      192.168.1.10    266
     192.168.1.10  255.255.255.255         On-link      192.168.1.10    266
    192.168.1.255  255.255.255.255         On-link      192.168.1.10    266
        224.0.0.0        240.0.0.0         On-link         127.0.0.1    306
        224.0.0.0        240.0.0.0         On-link         10.1.1.86    266
        224.0.0.0        240.0.0.0         On-link      192.168.1.10    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.220    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.221    266
        224.0.0.0        240.0.0.0         On-link     169.254.1.252    261
  255.255.255.255  255.255.255.255         On-link         127.0.0.1    306
  255.255.255.255  255.255.255.255         On-link         10.1.1.86    266
  255.255.255.255  255.255.255.255         On-link      192.168.1.10    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.220    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.221    266
  255.255.255.255  255.255.255.255         On-link     169.254.1.252    261
===========================================================================
Persistent Routes:
  Network Address          Netmask  Gateway Address  Metric
          0.0.0.0          0.0.0.0         10.1.1.1  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0    192.168.1.254  Default
===========================================================================


SQL-Node2

IPv4 Route Table
===========================================================================
Active Routes:
Network Destination        Netmask          Gateway       Interface  Metric
          0.0.0.0          0.0.0.0         10.1.1.1        10.1.1.87    266
          0.0.0.0          0.0.0.0    192.168.1.254     192.168.1.20    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.202    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.203    266
         10.1.1.0    255.255.255.0         On-link         10.1.1.87    266
        10.1.1.87  255.255.255.255         On-link         10.1.1.87    266
        10.1.1.88  255.255.255.255         On-link         10.1.1.87    266
       10.1.1.255  255.255.255.255         On-link         10.1.1.87    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.202    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.203    266
      10.1.10.202  255.255.255.255         On-link       10.1.10.202    266
      10.1.10.203  255.255.255.255         On-link       10.1.10.203    266
      10.1.10.222  255.255.255.255         On-link       10.1.10.203    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.202    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.203    266
        127.0.0.0        255.0.0.0         On-link         127.0.0.1    306
        127.0.0.1  255.255.255.255         On-link         127.0.0.1    306
  127.255.255.255  255.255.255.255         On-link         127.0.0.1    306
      192.168.1.0    255.255.255.0         On-link      192.168.1.20    266
     192.168.1.20  255.255.255.255         On-link      192.168.1.20    266
    192.168.1.100  255.255.255.255         On-link      192.168.1.20    266
    192.168.1.255  255.255.255.255         On-link      192.168.1.20    266
        224.0.0.0        240.0.0.0         On-link         127.0.0.1    306
        224.0.0.0        240.0.0.0         On-link         10.1.1.87    266
        224.0.0.0        240.0.0.0         On-link      192.168.1.20    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.202    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.203    266
  255.255.255.255  255.255.255.255         On-link         127.0.0.1    306
  255.255.255.255  255.255.255.255         On-link         10.1.1.87    266
  255.255.255.255  255.255.255.255         On-link      192.168.1.20    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.202    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.203    266
===========================================================================
Persistent Routes:
  Network Address          Netmask  Gateway Address  Metric
          0.0.0.0          0.0.0.0    192.168.1.254  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0         10.1.1.1  Default

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Here's what I've found so far. I have 2 NIC's that to out to the rest of the network. I was using 1, and I disabled the other. I'm assuming that it was trying to use the 'disabled' nic for internet. (Not sure why). However if I enable the second LAN nic on each server and place the respected IP values it works just fine.

However I don't want to have both of those nic's running at once. If I disable them, then it does this autoconfiguration setting that puts in private IPs (169.) But it's disabled so why?

Commented:
With incoming connections I assume the firewalls on the SQL nodes are enabled...how are the ping responses from google.com and then from the domain controller?

Author

Commented:
New route print.
IPv4 Route Table
===========================================================================
Active Routes:
Network Destination        Netmask          Gateway       Interface  Metric
          0.0.0.0          0.0.0.0         10.1.1.1        10.1.1.86    266
          0.0.0.0          0.0.0.0    192.168.1.254     192.168.1.10    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.220    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.221    266
          0.0.0.0          0.0.0.0         10.1.1.1       10.1.1.141     10
         10.1.1.0    255.255.255.0         On-link         10.1.1.86    266
         10.1.1.0    255.255.255.0         On-link        10.1.1.141    266
        10.1.1.86  255.255.255.255         On-link         10.1.1.86    266
       10.1.1.141  255.255.255.255         On-link        10.1.1.141    266
       10.1.1.255  255.255.255.255         On-link         10.1.1.86    266
       10.1.1.255  255.255.255.255         On-link        10.1.1.141    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.221    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.220    266
      10.1.10.220  255.255.255.255         On-link       10.1.10.220    266
      10.1.10.221  255.255.255.255         On-link       10.1.10.221    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.221    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.220    266
        127.0.0.0        255.0.0.0         On-link         127.0.0.1    306
        127.0.0.1  255.255.255.255         On-link         127.0.0.1    306
  127.255.255.255  255.255.255.255         On-link         127.0.0.1    306
      169.254.0.0      255.255.0.0         On-link     169.254.1.252    261
    169.254.1.252  255.255.255.255         On-link     169.254.1.252    261
  169.254.255.255  255.255.255.255         On-link     169.254.1.252    261
      192.168.1.0    255.255.255.0         On-link      192.168.1.10    266
     192.168.1.10  255.255.255.255         On-link      192.168.1.10    266
    192.168.1.255  255.255.255.255         On-link      192.168.1.10    266
        224.0.0.0        240.0.0.0         On-link         127.0.0.1    306
        224.0.0.0        240.0.0.0         On-link         10.1.1.86    266
        224.0.0.0        240.0.0.0         On-link      192.168.1.10    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.220    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.221    266
        224.0.0.0        240.0.0.0         On-link     169.254.1.252    261
        224.0.0.0        240.0.0.0         On-link        10.1.1.141    266
  255.255.255.255  255.255.255.255         On-link         127.0.0.1    306
  255.255.255.255  255.255.255.255         On-link         10.1.1.86    266
  255.255.255.255  255.255.255.255         On-link      192.168.1.10    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.220    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.221    266
  255.255.255.255  255.255.255.255         On-link     169.254.1.252    261
  255.255.255.255  255.255.255.255         On-link        10.1.1.141    266
===========================================================================
Persistent Routes:
  Network Address          Netmask  Gateway Address  Metric
          0.0.0.0          0.0.0.0         10.1.1.1  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0    192.168.1.254  Default
===========================================================================


SQL-node 2

IPv4 Route Table
===========================================================================
Active Routes:
Network Destination        Netmask          Gateway       Interface  Metric
          0.0.0.0          0.0.0.0         10.1.1.1        10.1.1.87    266
          0.0.0.0          0.0.0.0    192.168.1.254     192.168.1.20    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.202    266
          0.0.0.0          0.0.0.0      10.1.10.254      10.1.10.203    266
          0.0.0.0          0.0.0.0         10.1.1.1       10.1.1.142     10
         10.1.1.0    255.255.255.0         On-link         10.1.1.87    266
         10.1.1.0    255.255.255.0         On-link        10.1.1.142    266
        10.1.1.87  255.255.255.255         On-link         10.1.1.87    266
        10.1.1.88  255.255.255.255         On-link         10.1.1.87    266
       10.1.1.142  255.255.255.255         On-link        10.1.1.142    266
       10.1.1.255  255.255.255.255         On-link         10.1.1.87    266
       10.1.1.255  255.255.255.255         On-link        10.1.1.142    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.202    266
        10.1.10.0    255.255.255.0         On-link       10.1.10.203    266
      10.1.10.202  255.255.255.255         On-link       10.1.10.202    266
      10.1.10.203  255.255.255.255         On-link       10.1.10.203    266
      10.1.10.222  255.255.255.255         On-link       10.1.10.203    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.202    266
      10.1.10.255  255.255.255.255         On-link       10.1.10.203    266
        127.0.0.0        255.0.0.0         On-link         127.0.0.1    306
        127.0.0.1  255.255.255.255         On-link         127.0.0.1    306
  127.255.255.255  255.255.255.255         On-link         127.0.0.1    306
      169.254.0.0      255.255.0.0         On-link     169.254.2.179    261
    169.254.2.179  255.255.255.255         On-link     169.254.2.179    261
  169.254.255.255  255.255.255.255         On-link     169.254.2.179    261
      192.168.1.0    255.255.255.0         On-link      192.168.1.20    266
     192.168.1.20  255.255.255.255         On-link      192.168.1.20    266
    192.168.1.100  255.255.255.255         On-link      192.168.1.20    266
    192.168.1.255  255.255.255.255         On-link      192.168.1.20    266
        224.0.0.0        240.0.0.0         On-link         127.0.0.1    306
        224.0.0.0        240.0.0.0         On-link         10.1.1.87    266
        224.0.0.0        240.0.0.0         On-link      192.168.1.20    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.202    266
        224.0.0.0        240.0.0.0         On-link       10.1.10.203    266
        224.0.0.0        240.0.0.0         On-link     169.254.2.179    261
        224.0.0.0        240.0.0.0         On-link        10.1.1.142    266
  255.255.255.255  255.255.255.255         On-link         127.0.0.1    306
  255.255.255.255  255.255.255.255         On-link         10.1.1.87    266
  255.255.255.255  255.255.255.255         On-link      192.168.1.20    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.202    266
  255.255.255.255  255.255.255.255         On-link       10.1.10.203    266
  255.255.255.255  255.255.255.255         On-link     169.254.2.179    261
  255.255.255.255  255.255.255.255         On-link        10.1.1.142    266
===========================================================================
Persistent Routes:
  Network Address          Netmask  Gateway Address  Metric
          0.0.0.0          0.0.0.0    192.168.1.254  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0      10.1.10.254  Default
          0.0.0.0          0.0.0.0         10.1.1.1  Default
===========================================================================

Open in new window

Author

Commented:
firewalls on the SQL servers are disabled (software). I can nslookup and get an IP from doing a ping, however we dont' allow that traffic out. Only 80/443 traffic which works fine for other servers no the same network.

I added route print above. It wanted to go through the disabled nic that was set to 'autoconfig'. But i'm not sure why it's doing that.
Commented:
Try enabling the disabled nic and disabling the other. Switch them up and let me know if anything changes.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial