Agreed; I have vendors even now who try to get me to install a new instance of 2008 R2 for them :hehe:.

Snorting Bourbon sounds incredibly painful. I expect it would have the desired result, but you can't drive afterwards (primarily because you can't see :-D).

Do you have Vick's First Defence (First Defense ;-)) nasal spray over there? I find it quite good- not sure how scientific it is, but my theory is that it...

I was just coming to post that. It made my blood run cold.

We had them before the US, didn't we?

Do you mean that you're planning a hybrid setup, with one of your Availability Replicas on premises, and one on an Azure VM? What's your network link like; have you...

Edit: I've read this again and I see that you're specifically talking about Management Studio- sorry. Have you tried re-creating the Availability Group. No change?

Impossible to resist :-D!

I really enjoyed reading that, Hugo.

Just to eliminate the obvious, have you tried doing this on each other's machines to rule out any hardware discrepancies?

I don't think so.

Are some of them connecting locally and some remotely, or anything like that?

In the UK there has been quite a lot of resistance to implementing a centralised repository of all health records, and this kind of thing is exactly why. I opted...

It's by design: https://msdn.microsoft.com/en-us/library/bb934126.aspx

3.In the New Server Registration dialog box, select the instance of SQL Server that you want to become the central management server from the drop-down list of...

FNS (11/18/2016)

---

I wondered if anyone had any suggestions or ideas on why our clustered primary copy in an availability group will only move from it's initial node to the other...