Configure Read Only Routing

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

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

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

  • thanks for posting and sharing information.

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

  • 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));

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • How can i configure it without DOMAIN ?

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

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