We figured it out kind of. We rebooted both nodes and things fell back into synch. Do I know the initial cause? No I don't.

For the sake of answering the...

No readonly routing configured. B is just for DR.

Johan Bijnens - as I said before, this cluster has been functioning fine for months, as long as B isn't the primary. This problem started 3 days ago.

Again, I'm not...

Redundancy. Disaster recovery. There's 2 reasons. And as I said, it's not intended that B can't be functional as the primary. We'll get there, but that is not my immediate...

So the 1st 2 nodes are exactly what I expect to see. A is primary. B is secondary. The problem is in the last one. I need the listener to...

I have manually failed over back and forth several times now to no avail. The overall servername lands on the secondary node, whichever that happens to be. Shouldn't the listener...

That makes total sense. I guess thoroughly asking the question sometimes provides the answer 🙂 Thanks

I should have worded differently. I guess what I'm asking is if there's a way to have more than one AG use the same listener.

Yes, I have local admin on the server and sysadmin in the SQL instance.

principal_id = 1 is a named login belonging to a 3rd party vendor. Prior to my hiring,...

Thank you. I was confused. I've been using this forum for over a decade and was certain I hadn't violated any rules. I had asked a slightly similar question recently...

The upgrade to the 2012 did the trick. I cannot wait to sever the inadvertent links between all these servers. I only described 2 in this scenario. There are so...

Thanks for chiming in Leo.

I looked at the Catalog table on Server1 vs Server2. Both are populated, but with different things. However, this doesn't help me because neither ReportManager will...

Thanks Sue. I checked it out and will be updating the prod server tomorrow night off hours. Nonetheless, I don't understand how updating 1 server affected another. The only link...

My 2 cents is that a downgrade sounds like a very bad idea. I typically won't even risk upgrading in-place for the reason Grant gave. With in-place, if something goes...

Thanks. I was thinking it wasn't possible, but wanted to make sure I wasn't overreacting and missing something.