Availability group basic question

• as_1234

  SSCrazy

  Points: 2865

  More actions

  September 6, 2017 at 9:14 am

  #325220

  All,

  Apologises this is probably a basic question.

  I've just installed two SQL2016 servers and created an availability group.

  The AG dashboard is telling me that the secondary isn't connected and I can't work out why.

  I've checked the following:

  SELECT role FROM sys.database_mirroring_endpoints;

  returns 3 for both servers

  The sql services on both servers are running under a domain account and are both started.

  The firewall on both servers are off

  Could anyone advise what I have missed. Apologises for the basic question.

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  September 6, 2017 at 2:04 pm

  #1958444

  Try running through the list in of possible causes in this article:
  Availability replica is disconnected

  You can also sometimes find errors for the issue in the SQL Server logs (check both instances) as well as the Windows logs.

  Sue

• as_1234

  SSCrazy

  Points: 2865

  More actions

  September 6, 2017 at 2:45 pm

  #1958451

  Hello,

  Thanks. Sorry, SQL logs should have been an obvious place for me to look.

  They showed a permission issue on one of the endpoint. A service restart on the secondary and a recreation of the AG fixed it.

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  September 6, 2017 at 3:03 pm

  #1958453

  as1981 - Wednesday, September 6, 2017 2:45 PM

  Hello,

  Thanks. Sorry, SQL logs should have been an obvious place for me to look.

  They showed a permission issue on one of the endpoint. A service restart on the secondary and a recreation of the AG fixed it.

  Thanks

  No worries...glad it's all good now. Thanks for posting back everything - that really helps when people do that so that others finding your post can try some of the same things.

  Sue