“Value cannot be null” when i connect SQL Server from SSMS
Posted by Karthick P.K on May 26, 2010
I get this below when I connect to SQL Server using SSMS…… What should i do?
Error
Value cannot be null.
Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)
Resolution
Right click SSMS “run as administrator” 
If the “run as administrator doesn’t resolve the problem verify if %Temp% environment variable to set properly for the logged on widows account
If %Temp% is not set properly in environment variables we might end up with error.
If you liked this post, do like us on FaceBook at
https://www.facebook.com/mssqlwiki
and join our FaceBook group
https://www.facebook.com/mssqlwiki#!/groups
Karthick P.K |Technical Lead | Microsoft SQL Server Support |My Facebook Page |My Site| Blog space| Twitter
Regina said
It does help!
Thank you!
–R
Suhas said
Can you let us know the cause of the issue? I mean, why does “Run as Administrator” fix the problem.
Sorry, but I feel it a big challenge to remember to launch SSMS everytime as “Run as Administrator”.
Suhas
Karthick P.K said
Hello Suhas,
Disable UAC at your own risk
.
When UAC is enabled and if you open SSMS as standard user you may not get full permissions on C:\Users\Username\AppData\Local\Microsoft\ (or) %Temp% dir.
This will cause “Value cannot be null.” Error.
Even if %Temp% is not set properly in environment variables we might end up with error.
More info about UAC on http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx
Thanks
Karthick P.K
Srikanth Jasti said
Hi I am also getting same error but if I try to run as administrator still I am getting the same error…. what could be the problem anyone help me?
Karthick P.K said
Check if environment variable for TEMP has valid path
Sane said
Karthick P.K said
August 12, 2012 at 3:59 AM
Check if environment variable for TEMP has valid path
——————————————————————————————-
Also check that there is space for the Temp
Carl said
It also appears to be a sympton of running out of space on the C drive.