Skip to content

Value cannot be null

25/09/2013

After issues with my laptop not being able to find critical files this morning I managed to boot to the last know good configuration. This seemed to have got me past all the errors I previously had, however, I noticed that things weren’t quite right.

When attempting to open SQL Server Management Studio (SSMS) 2012 I received the error “Value cannot be null.” – this appeared when first connecting and then when expanding any of the nodes underneath the database server.

Also missing were the Local Server Groups and Central Management Servers child nodes in the Registered Servers panel.

Value cannot be null

 

Red Herring

On one Microsoft forum I found a proposed answer from a Microsoft employee who said they had been able to replicate the error and the fix was to repair the .NET 4 framework. I tried this and it made no difference whatsoever – it may work for you, please feel free to leave a comment if you had any luck with this.

Fixing the error

I found a workaround for this which is to right click the SSMS shortcut and “Run as Administrator”. This did seem to work but wasn’t a proper fix so I continued researching.

The fix comes in the form of Environmental Variables, setting the User variable TEMP and the System variable TMP to the appropriate locations (C:\users\<user.name>\AppData\Local\Temp) worked for me, I was then able to open SSMS fine with no errors.

Advertisements

From → SQL Server

Leave a Comment

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: