SQL Server 2016 AG Setup Part 5–AG2 between SQL01\AGINST2 and SQL02\AGINST2

During this example, same port has been used for as part of illustration. Different port number between AG and instance is not a requirement, it’s a best practice instead as one instance can support multiple AG groups.






Important point: Since we already have AG1 running with different SQL instances on port 5022, we need to choose different port here to avoid conflict.









Make sure SQL01\AGINST2 and SQL02\AGINST2 only listen on specific IP, instead of “LISTEN ALL”, that will block AG Listener binding to same port.








Otherwise connection to AG Listener won’t be successfully.