Configure Read Only Routing

  • gana20m

    SSCrazy

    Points: 2418

    Comments posted to this topic are about the item Configure Read Only Routing

    Regards,
    Ganapathi varma, MCSA
    Email: gana20m@gmail.com

  • SQL Surfer '66

    SSCertifiable

    Points: 5152

    SQL Server Management Studio 17.3 added support for Read-Only Routing:

  • gana20m

    SSCrazy

    Points: 2418

    thanks for posting and sharing information.

    Regards,
    Ganapathi varma, MCSA
    Email: gana20m@gmail.com

  • Perry Whittle

    SSC Guru

    Points: 233784

    if you're going to all the trouble of first opening the AG properties and setting the secondaries to Read_Intent, then you do not need to run this part of the script for each replica

    ALTER AVAILABILITY GROUP [AGTEST01] MODIFY REPLICA ON N'DB2' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • borispinsky

    Valued Member

    Points: 74

    How can i configure it without DOMAIN ?

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

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