Post reply

Error connecting to the Read-Only Replica from Application

  • November 4, 2021 at 1:59 pm

    #3947892

    Dear Friends,

    I have a Read-Scale setup with 2 nodes , and one of them being 'Read-Only' replica. The connections work well at the Database Level but throws an error at the Application Level ,from DevOps ,(as in the attachment) when I go and test the Read-Only replica .I got the same error from SSMS, but could still connect and open the Query editor clicking on the 'Synchronizing' database on the secondary and run some select queries(with the DML's failing as expected). Thank you for any help in this.

    Best Regards...Arshad

    • This topic was modified 3 years ago by  Arsh.

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

  • November 4, 2021 at 4:31 pm

    #3947968

    Your secondary is not configured to allow a readable secondary. Screenshot 2021-11-04 123107

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • November 7, 2021 at 1:00 pm

    #3948793

    Hi Michael,

    Thanks for pointing this. I did configure them and now it works...Thank you.

     

    Best Regards..Arshad

    • This reply was modified 3 years ago by  Arsh.

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

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