//Friday 6 June 2014

Value cannot be null error when starting Sql Server Management Studio 2008 R2

Started getting a "Value cannot be null" error dialog after connecting to a local SQL server instance on one of our development servers.

It turns out SSMS is looking for a random Temp folder that must have been cleared down at some point. I created the folder C:\Users\Administrator\AppData\Local\Temp\2 and SSMS started working again as expected. Another helpful error message from Microsoft.

Found the solution deep in this forum post:


Search for %TEMP%