Post reply

Availability group basic question

  • 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

  • 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

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply