Configure Read Only Routing

• gana20m

  SSCrazy

  Points: 2443

  More actions

  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

• SQL Surfer '66

  SSCertifiable

  Points: 5161

  More actions

  February 5, 2018 at 6:43 am

  #1978534

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

  

• gana20m

  SSCrazy

  Points: 2443

  More actions

  February 5, 2018 at 7:08 am

  #1978542

  thanks for posting and sharing information.

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

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  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"

• borispinsky

  SSC Journeyman

  Points: 78

  More actions

  March 19, 2018 at 4:01 am

  #1983733

  How can i configure it without DOMAIN ?