none
primary_role_allow_connections_desc RRS feed

  • Question

  • What's the difference for the following

    primary_role_allow_connections_desc : ALL vs Read-write

    secondary_role_allow_connections: Read-only and all ?

    Monday, August 12, 2019 3:36 AM

Answers

  • what's the different of "All" and "Read-Write" for primary ?
    Hi sakurai_db,

    For the primary role:

    Allow all connections
    All connections are allowed to the databases in the primary replica. This is the default setting.

    Allow read/write connections
    When the Application Intent property is set to ReadWrite or the Application Intent connection property is not set, the connection is allowed. Connections where the Application Intent connection property is set to ReadOnly are not allowed. This can help prevent customers from connecting a read-intent work load to the primary replica by mistake. 

    Please refer to  configure access on an availability replica to get more information.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by sakurai_db Saturday, August 24, 2019 4:00 PM
    Friday, August 23, 2019 9:31 AM

All replies

  • Hi sakurai_db,

    We can get the information from the screenshot that you provide, and the description of the values are clearly. The values determine the kinds of connections that the AG allows to be connected. All connections or read Write or read only? But there is a difference for the AG primary replica and secondary replica.

    By default both read-write and read-intent access are allowed to the primary replica and no connections are allowed to secondary replicas of an Always On availability group. But we can change it, please refer to this document to get more information.

    If I misunderstood your issue, please let me know. 

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, August 13, 2019 3:07 AM
  • so what's the difference ?

    Allow All connections vs Allow read/write connections

    Yes and Read-intent only

    Tuesday, August 13, 2019 9:27 AM
  • so what's the difference ?

    Allow All connections vs Allow read/write connections

    Yes and Read-intent only

    Hi sakurai_db,

    Could you please read the official document again, you can get the result there.

    Or did I misunderstand your issue? Did you want to know the difference about Allow All connections vs Allow read/write connections and Yes and Read-intent only?

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, August 13, 2019 10:12 AM
  • If your secondary databases are configured for read only only applications using application intent of readonly will be able to access them. If they are not using the application intent setting of read only, their connection attempt will fail.

    If they are set to all, then any connection can connect to the secondary replica databases and read them.

    Tuesday, August 13, 2019 1:59 PM
  • Hi sakurai_db,

    Did you resolve your issue? If you have resolved your issue, please mark the useful reply as answer. It will make it easier for other community members to find the useful ones.

    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, August 21, 2019 10:03 AM
  • what's the different of "All" and "Read-Write" for primary ?
    Thursday, August 22, 2019 3:14 PM
  • what's the different of "All" and "Read-Write" for primary ?
    Hi sakurai_db,

    For the primary role:

    Allow all connections
    All connections are allowed to the databases in the primary replica. This is the default setting.

    Allow read/write connections
    When the Application Intent property is set to ReadWrite or the Application Intent connection property is not set, the connection is allowed. Connections where the Application Intent connection property is set to ReadOnly are not allowed. This can help prevent customers from connecting a read-intent work load to the primary replica by mistake. 

    Please refer to  configure access on an availability replica to get more information.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by sakurai_db Saturday, August 24, 2019 4:00 PM
    Friday, August 23, 2019 9:31 AM