I'm currently setting up a new database environment at work.
We have two SQL 2016 servers across our infrastructure that needs to be setted up with Availability Groups.
I read and followed several tutorials but I'm facing an issue that I can't solved.
I have a Windows Failover Cluster that's running fine, no error and so on.
I then have created an Availability Group between my SQL servers and everything went fine too.
All the check during the configuration went perfectly and the Availablity Group has been created.
But here comes the thing, when I check on my availability replicas, it says that my secondary replica is in critical state with several warning/errors messages and so the databases aren't replicating. When I check these messages, it says that my secondary replica is not connected to my primary one, the connected state is DISCONNECTED.
But I can't figure out why, I allowed everything necessary in our firewall, and I can't see anything denied between the two servers.
Thus, during the creation of the availability group, the servers can perfectly join each others and I can see that the group has been created on both servers...
It's the first time I'm working with availability groups so maybe I missed something somewhere, but nothing that has been mentionned on the different tutorial I've read.