Post reply

Configure Read Only Routing

  • February 4, 2018 at 8:06 am

    #327225

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

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

  • February 5, 2018 at 6:43 am

    #1978534

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

  • February 5, 2018 at 7:08 am

    #1978542

    thanks for posting and sharing information.

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

  • February 5, 2018 at 9:41 am

    #1978582

    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" 😉

  • March 19, 2018 at 4:01 am

    #1983733

    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