We have a two-node multi-subnet Windows Server 2012 R2 cluster in two regions. We have three named SQL Server 2012 standalone instances on each node and are in the process of setting up Availability Groups on each SQL instance. I have set one up on one instance successfully, but when I try to set up the second AG on the second named instance I get the following error message:
A connection timeout has occurred while attempting to establish a connection to availability replica
[567C-F10B-43C3-A2DB-BEDDD307589B]. Either a networking or firewall issue exists, or the endpoint address provided for the replica is not the database mirroring endpoint of the host server instance."
It looks like it does not support multiple endpoints with different ports on a single node. Has anyone come across this scenario? First instance, I used 5023 as the end point port and for the second I used 5022. But I cannot telnet from node 2 to 1 on port 5023 whereas I can telnet from Node 1 to 2 on port 5023. Node 1 is not listening that port.
My simple question: Is the following setup supported?
Having multiple SQL named instances on two node windows cluster and Always On Availability Groups on each Instance.
Example of my setup:
Node1 Named instances: SQLINS1, SQLINS2 Availability Groups - AO1 on SQLINS1 and AO2 on SQLINST2 Node2 Named instances: - SQLINS3, SQLINS4 Availability Groups - AO1 on SQLINS3 and AO2 on SQLINST4
Replicas of AO1: SQLINS1, SQLINS3 Replicas of AO2: SQLINS2, SQLINS4
If my question is not clear I am happy to give you more details about the setup which I am trying.