none
Readable Secondary yes option not available RRS feed

Answers

  • Hi Curendra,

    Which edition of SQL server it is?

    If it Standard Edition that only supports Basic Availability Groups, which do not allow read access on a secondary replica: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-


    Please click "Mark as Answer" if it solved your issue and/or "Vote as helpful" if it helped. This can be beneficial to other community members reading this thread.

    • Marked as answer by Curendra Friday, August 30, 2019 8:37 AM
    Thursday, August 29, 2019 2:07 PM
  • Hi Curendra,

     

    You need to  change the readable secondary option on the primary replica and the readable secondary doesn't support on the standard edition.

     

    Best regards,

    Dedmon Dai


    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 Curendra Friday, August 30, 2019 8:37 AM
    Friday, August 30, 2019 2:46 AM

All replies

  • Hi,

    Can you confirm that you are logged and connected to NODE1 in SSMS when you are trying to make this change?  I cant see from the screenshot whether you see any other options in the drop down other than 'No'?

    Thanks,

    Matt

    Thursday, August 29, 2019 1:48 PM
  • Hi Curendra,

    Which edition of SQL server it is?

    If it Standard Edition that only supports Basic Availability Groups, which do not allow read access on a secondary replica: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-


    Please click "Mark as Answer" if it solved your issue and/or "Vote as helpful" if it helped. This can be beneficial to other community members reading this thread.

    • Marked as answer by Curendra Friday, August 30, 2019 8:37 AM
    Thursday, August 29, 2019 2:07 PM
  • Hi Curendra,

     

    You need to  change the readable secondary option on the primary replica and the readable secondary doesn't support on the standard edition.

     

    Best regards,

    Dedmon Dai


    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 Curendra Friday, August 30, 2019 8:37 AM
    Friday, August 30, 2019 2:46 AM