Pages

Social Icons

Monday 18 March 2013

“Value cannot be null” when i connect SQL Server from SSMS



I got below error while connecting SQL-Server using SSMS from my friend machine.

Error :

Value cannot be null.
Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

Solution :

Right click SSMS   “run as administrator”   

If the “run as administrator doesn’t solve the problem then go to My Computer > Right Click > Properties and then choose “Advanced”. Then click on “Environment Variables” Now, change TMP and TEMP to valid location. On my machines its “%USERPROFILE%\AppData\Local\Temp” 

Problem Solved