Forum Discussion
sharrock1985
Nov 12, 2024Copper Contributor
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;
- Verify Listener Configuration: Ensure that the listener is correctly configured and associated with the availability group.
- Check Permissions: Make sure that the account you’re using to connect via the listener has the necessary permissions.
- SSMS Version: Ensure that you are using a compatible version of SSMS that supports Always On Availability Groups.
- Cluster Dependencies: If the listener was created via the Windows Failover Cluster Manager, ensure that the AG resource is dependent on the listener.
- Network Configuration: Verify that the network configuration for the listener is correct, including DNS settings and IP addresses.
- SSMS Refresh: Sometimes, simply refreshing the SSMS view or reconnecting can resolve display issues.
No RepliesBe the first to reply