July 18, 2017 at 12:20 pm
Hello,
first of all sorry for my english...
i have 2 SQL Server 2014(VM-Ware) running on Win Server 2012R2, each has 2 DB Engines. Let's say Server A, with DB Engines 1 and 2, Server B with DB Engines 1 and 2. On each server 2 NIC, two separated VLAN's.
SQL Network Configuration:
ServerA-Instance1: 10.xx.151.xx
ServerA-Instance2: 10.xx.152.xx
ServerB-Instance1: 10.xx.151.xx
ServerB-Instance2: 10.xx.152.xx
I created then Windows Failovercluster with File Share Witness on third Server which is outside of Cluster.
I have two AAgroups:
AAGroup1: ServerAInstance1 <-> ServerBInstance1
AAGroup2: ServerAInstance2 <-> ServerBInstance2
Each Group has Listener, each Listener has IP Adress in same IP Adress range like DB Engines that are in same AAGroup.
Even Listener Ports are different. But every Time when i try to connect to AAGroup2 over the Listener2, it shows me AAGroup1.... What am i doin' wrong? Best regards & thank you in advance
Denis
July 19, 2017 at 5:25 am
start here
http://www.sqlservercentral.com/stairway/112556/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2017 at 9:01 am
Thank you Perry, great stuff.
How did i solve it: https://sqlperformance.com/2012/10/system-configuration/dedicated-network-availability-group
Regards
Denis
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply