‘Object Reference Not Set to an Instance of an Object’ When Failing Over an Availability Group Using SSMS <= 17.5

Panic_button

Here’s a quickie that I’ve just stumbled across.

I’ve just tried to initiate a manual failover of an availability group and received the following error.

failover

After a spot of head scratching and thinking that there was something wrong with my AG setup, it turns out that there’s a bug in SSMS.  I was running SSMS 17.5 although this may well also affect earlier versions.

Looking at the release notes for SSMS 17.6, one of the bug fixes that this version addresses is…

  • Fixed an issue when the primary is down and manually failover to secondary, a NullReferenceException will be thrown.

After installing SSMS 17.6 I was able to perform the failover and get things back up and running.

Luckily for me, I came across this while performing some DR testing exercises.  I’d hate to have hit this issue during a genuine DR situation.  Hopefully this post might help someone who does find themselves in that position or at least nudge you in the direction of upgrading your SSMS to the latest version.

 

One thought on “‘Object Reference Not Set to an Instance of an Object’ When Failing Over an Availability Group Using SSMS <= 17.5

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: