//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:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7e0287b3-cd37-408e-8145-4b9dba8c7811/value-cannot-be-null-in-2008-r2-ssms-studio-package-failed-to-load?forum=sqltools

Search for %TEMP%

SyntaxHighlighter