0

Question:

Why is my routing list empty? I have removed the secondary from the AG and re-added back, everything is healthy and synchronized. lets assume for the example that server1 is currently the primary. What can I check or try to troubleshoot?

This works fine in our development environment but not in others.

(Last picture shows what I see in development environment)

image of AG settings

Picture of AG Dashboard everything is healthy no issues

as you can see the boxes are empty

Development Screenshot

Sean Gallardy
  • 38,135
  • 3
  • 49
  • 91
Mike Kay
  • 1

1 Answers1

1

Why is my routing list empty?

Looks like it wasn't configured.

In your screenshot below, there is no read-only routing url specified so you won't be able to add that to the list. Put in a correct read-only routing URL for each instance and you'll be able to manipulate the routing list.

Empty read-only routing URL

Sean Gallardy
  • 38,135
  • 3
  • 49
  • 91