none
ODBC 64 bit connect to Always on read replica RRS feed

  • Question

  • Hi Currently we have sql server 2016 R2  and always on , two node cluster(node 2 is read only ). now business need to connect read only site using Listener name  to "read only " replica for reporting. When connect to  ODBC driver , not sure the connection goes to secondary read only site. Then how to configure ODBC to connect read replica for reporting purpose. This setup required for power BI desktop users to connect to database from their laptops 

    Any experts ideas would be highly appreciated . 

     

    Monday, August 19, 2019 6:11 AM

All replies

  • Use ApplicationIntent = READONLY, see Connection Options

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Monday, August 19, 2019 8:04 AM
  • Hi ashwan,

     

    Have you successfully configured read-only routing? If you have already configured it, you only need to add ApplicationIntent = READONLY to the connection string.

     

     

     

    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

    Tuesday, August 20, 2019 8:42 AM