I have just installed a sql server availability group,
always on, with 2 servers,
SQLPROD2_TS as you can see on the picture below:
select distinct rcs.database_name, ar.replica_server_name, drs.synchronization_state_desc, drs.synchronization_health_desc, CASE rcs.is_failover_ready WHEN 0 THEN 'Data Loss' WHEN 1 THEN 'No Data Loss' ELSE '' END as FailoverReady from sys.dm_hadr_database_replica_states drs inner join sys.availability_replicas ar on drs.replica_id = ar.replica_id and drs.group_id = ar.group_id inner join sys.dm_hadr_database_replica_cluster_states rcs on drs.replica_id = rcs.replica_id order by replica_server_name
the listener for the availability group is calle
SQLPROD_TS as you can see on the picture below
select * from sys.availability_group_listener_ip_addresses select * from sys.availability_group_listeners select * from sys.dm_tcp_listener_states
all is good, however, when I ask people to connect to
SQLPROD_TS when they browse the network they can only see the nodes of the cluster.
Is there a way I could make
sqlProd_ts to show up on the picture above, instead of the nodes?