December 13, 2017 at 4:35 am
I have issue with my SQL AG; when I am doing a failover I can't ping anymore the listener
I have double check firewall on all SQL servers and it is not active
Here an overview of my environment
2 SQL 2014 server configure in 2 AG; one for each SQL Instance
Server one
2 instance
public lan : 10.10.0.x /24
Windows failover cluster network (private or Heartbeat) : 10.10.2.x /24
AG replication network instance 1: 10.10.3.x /24 on port 5022
AG replication network instance 1: 10.10.3.x /24 on port 5023
listener instance 1: 10.10.0.x /24 on port 1433
listener instance 2: 10.10.0.x /24 on port 2020
Server Two
public lan : 10.10.0.x /24
Windows failover cluster network (private or Heartbeat) : 10.10.2.x /24
AG replication network Instance One: 10.10.3.x /24 port 5022
AG replication network instance 1: 10.10.3.x /24 on port 5023
listener Instance one: 10.10.0.x /24 port 1433
listener instance 2: 10.10.0.x /24 on port 2020
Scenario 1
start a ping to the listener name
After a failover to the secondary if the pc is on the same network than the public network and the listener (10.10.0.x /24) the ping is lost for a ping or two and the ping come back. The ping is done on the listener DNS Name
connection to SSMS are working with both listener name and sql instance name
Scenario 2
start a ping to the listener name
after a failover to the secondary if the pc is not on the same network than the public and listener network (10.10.0.x /24) the ping is lost and doesn't come back. To get the ping back I have to failover back to the primary. For example if I am doing the ping from my workstation I lost the ping until the failover to the primary occured
connection to SMSS are not working with the listener name but are working with the sql instance name
never lost ping to sql servers by using the windows computer name
seems strange to me
thanks for your help
December 13, 2017 at 9:56 am
confirm you are using an IP in the range of your Public LAN
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2017 at 12:22 pm
Yes I confirm the listener ip is in the range of the public IP, both are in 10.10.0.x /24
thanks
December 15, 2017 at 9:07 am
how many IPs are assigned to the listener?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply