SQLTeam.com | Weblogs | Forums

AG Listener not listening

sql2014

#1

I have an always on Availability Group set up with ta listener. the properties of the listener are still correct. I was setting up a service broker last night and managed to muck it up.

The listener isn't listening anymore on the specified port. I verified properties of the listener and they haven't changed, the only thing that appears to be different is the results in
SELECT *
FROM sys.dm_tcp_listener_states

the IP address and port for the AG Listener are no longer there for TSQL

I see nothing out of the ordinary in the sys.endpoints or the sys.tcp_endpoints

I am not sure how to correct other than rebuild the AG listener what do you think?


#2

It sounds like Service Broker has taken over the port. Did you remove Service Broker?


#3

It did, I fixed the Service broker to 4022 and that fixed the connection issue but the Service broker doesn't appear to be running,

I did this:

CREATE ENDPOINT [New end point]
STATE = STARTED
AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL )
FOR SERVICE_BROKER (AUTHENTICATION = WINDOWS)

then I Altered the routes
ALTER ROUTE [ListenerRouteToService] WITH
SERVICE_NAME = '//ServiceName',
ADDRESS = 'TCP://AGGroupListener:Port;