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

3 comments:

  1. It works for me :) Thanks a ton

    ReplyDelete
  2. its not works for me :(

    ReplyDelete
  3. thank you ,, that makes me happy and work very good

    ReplyDelete