SSMS connections to Availability Groups

  • nonsqldba

    SSC Rookie

    Points: 33

    Hello,

    I am new to Sql server and have a question on SSMS connecting to AGs. When I connect to the primary node the database has a white circle on it and on the secondary node it has a green arrow. I would think it should be the other way around. Primary should show a green light, no?

    Thanks for entertaining my silly question.

  • Jeffrey Williams

    SSC Guru

    Points: 88696

    Where are you seeing this - a little more context would be helpful.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • nonsqldba

    SSC Rookie

    Points: 33

    Please see the attached images.

    Thanks!

    Attachments:
    You must be logged in to view attached files.
  • CC-597066

    SSCommitted

    Points: 1588

    Ideally all your SQL servers should show a green arrow.

    I find that I have to enable a couple of firewall rules for Windows Management Instrumentation for that to happen, DCOM-In and WMI-In.

     

    Attachments:
    You must be logged in to view attached files.

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

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