locked
Can't create Listener in Availability Group SQL Server RRS feed

  • Question

  • Hi everyone,

    I have 2 servers hosted on AWS. Both are running SQL Server Standard 2016.

    The first one is on subnet A, 2nd one is on subnet B.

    Subnet A is: 10.0.7.0/24 and i already assigned 10.0.7.67 in Failover Cluster Manager

    Subnet B is: 10.0.9.0/24 with 10.0.9.67 assigned in Failover Cluster Manager

    The first one on subnet A would be primary,

    The 2nd one on subnet B would be secondary.

    When i was creating Basic Availability Group and gave Listener 2 IP: 10.0.7.77 and 10.0.9.77. Everything seems fine but i got stuck at the last issue which is "joining to availability group". It got stuck for a very long time (> 1 hour) so i couldn't know what to do.

    Thursday, March 1, 2018 9:12 AM

All replies

  • More details here

    https://community.spiceworks.com/topic/2116424-can-t-create-listener-in-availability-group-sql-server?page=1#entry-7588332

    Friday, March 2, 2018 8:56 AM