Forum Discussion

sharrock1985's avatar
sharrock1985
Copper Contributor
Nov 12, 2024

AG Server Listener Issue

When I connect to a newly set up AG-Server using the Listener in SSMS, I don't get the Always on High Availability Folder.

I can logon as the Primary / Secondary / Cluster … All show the Always on High Availability Folder in SSMS Logon has the Listener no Folder. 

 

When I use the another AG-Server Listen which was set up ages ago all good.

 

I asked co-pilot and check all these are ok;

 

  1. Verify Listener Configuration: Ensure that the listener is correctly configured and associated with the availability group.
  2. Check Permissions: Make sure that the account you’re using to connect via the listener has the necessary permissions. 
  3. SSMS Version: Ensure that you are using a compatible version of SSMS that supports Always On Availability Groups. 
  4. Cluster Dependencies: If the listener was created via the Windows Failover Cluster Manager, ensure that the AG resource is dependent on the listener. 
  5. Network Configuration: Verify that the network configuration for the listener is correct, including DNS settings and IP addresses. 
  6. SSMS Refresh: Sometimes, simply refreshing the SSMS view or reconnecting can resolve display issues. 
No RepliesBe the first to reply

Resources