ALTER AVAILABILITY GROUP [OCSAG]
 
 MODIFY REPLICA ON
 
N'OCSDEV1' WITH
 
(SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
 
ALTER AVAILABILITY GROUP [OCSAG]
 
 MODIFY REPLICA ON
 
N'OCSDEV1' WITH
 
(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://OCSDEV1.ad.romanability.com:1433'));

ALTER AVAILABILITY GROUP [OCSAG]
 
 MODIFY REPLICA ON
 
N'OCSDEV2' WITH
 
(SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
 
ALTER AVAILABILITY GROUP [OCSAG]
 
 MODIFY REPLICA ON
 
N'OCSDEV2' WITH
 
(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://OCSDEV2.ad.romanability.com:1433'));

ALTER AVAILABILITY GROUP [OCSAG]
 
MODIFY REPLICA ON
 
N'OCSDEV1' WITH
 
(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('OCSDEV2')));
 
 
 
ALTER AVAILABILITY GROUP [OCSAG]
 
MODIFY REPLICA ON
 
N'OCSDEV2' WITH
 
(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('OCSDEV1')));

SELECT	  AVGSrc.replica_server_name AS SourceReplica		
		, AVGRepl.replica_server_name AS ReadOnlyReplica
		, AVGRepl.read_only_routing_url AS RoutingURL
		, AVGRL.routing_priority AS RoutingPriority
FROM sys.availability_read_only_routing_lists AVGRL
INNER JOIN sys.availability_replicas AVGSrc ON AVGRL.replica_id = AVGSrc.replica_id
INNER JOIN sys.availability_replicas AVGRepl ON AVGRL.read_only_replica_id = AVGRepl.replica_id
INNER JOIN sys.availability_groups AV ON AV.group_id = AVGSrc.group_id
ORDER BY SourceReplica

SELECT replica_server_name
	, read_only_routing_url
	, secondary_role_allow_connections_desc
FROM sys.availability_replicas