Always on cluster in GCP having 2 listener ip for 2 different sql instance on 2 node cluster. Why both sql instance not running on same node. ? I can able to run only one sql instance on each node at a time not both sql instance on same node.
Cluster ip - IP1
Server A - SQL1 - IP2,1433
Server A - SQL2 - IP2,1435
Server B - SQL1 - IP3,1433
Server B- SQL2 - IP3, 1435
Always on groups:
AGSQL1 – Sql1 to sql 1 (listener IP 1 )
AGSQL2 – Sql2 to sql2 (listener IP 2 )
question: AGSQL1 and AGSQL2 is not coming online together on single node. I can run one group on either of one node only. why? Is it not possible due to limitation in GCP?