Source: dba.stackexchange.com --- Saturday, July 29, 2017
I have 2 servers running Windows Server 2016 with Microsoft SQL Server 2016 Enterprise. I have created a fail over cluster in Windows and joined both nodes without Active Directory. Then I created an availability group with both nodes and everything is fine and the database is synchronized. Now I created the AG listener, I am not using DHCP, so I assigned a static IP. What I don't understand is how the fail over is going to work; when I connect to the listener everything is fine when Node1 is primary, when I do manual failover to Node2, I can't connect. How will the listener switch to node2? Should the listener have 2 IPs for both nodes? BTW, the servers are not on a private LAN. ...
from Windows http://ift.tt/2tT4ujE
No comments:
Post a Comment