Hello,
I am attempting to set up a secondary NIC connection between two servers that will be participating in SQL Server Merge Replication. However, when I enable the two secondary NICs that are connected via a crossover cable, something happens that jams up traffic connecting to the SQL server.
Here is my configuration:
Server1
NIC 1:
IPv4 Address. . . . . . . . . . . : 192.168.10.7(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.10.1
DNS Servers . . . . . . . . . . . : 192.168.1.9, 192.168.1.7
NIC 2 (for replication traffic)
IPv4 Address. . . . . . . . . . . : 192.168.18.11
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DNS Servers . . . . . . . . . . . :
Server2
NIC 1:
IPv4 Address. . . . . . . . . . . : 192.168.10.8(Preferred)
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.10.1
DNS Servers . . . . . . . . . . . : 192.168.1.9, 192.168.1.7
NIC 2 (for replication traffic)
IPv4 Address. . . . . . . . . . . : 192.168.18.12
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
DNS Servers . . . . . . . . . . . :
I also put an entry into each server's host file like so:
192.168.18.12 server2.mydomain.com (for server 1's file)
192.168.18.11 server1.mydomain.com (for server 2's file)
I can ping server1 from from server2 (and vise versa) and it referenced the .18 subnet, but if I try to connect to the SQL Server over the .18 IP, it can't find the server.
Any ideas as to what I am doing wrong here? I will eventually be setting up NLB on these servers as well to load balance read requests to the database. I would like to route heartbeat traffic over this connection as well.
Thanks!
Christine