MSSQLWIKI

Karthick P.K on SQL Server

“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

Thank you,

Karthick P.K |Technical Lead | Microsoft SQL Server Support  |My Facebook Page |My Site| Blog space| Twitter

About these ads

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

  1. Regina said

    It does help! :-)
    Thank you!
    –R

  2. 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

  3. 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?

    • 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

  4. Carl said

    It also appears to be a sympton of running out of space on the C drive.

  5. 1.Go to windows Run and search there name like %temp% .

    2.Below path will be opened on new windows.

    C:\Users\Administrator\AppData\Local\Temp

    3. Above path you have to create one folder & its name is 2. Like as below.
    C:\Users\Administrator\AppData\Local\Temp\2

    4. Now close the session of SQL server and start the Management studio.Your SQL will be work properly.

    I have resolved the said issues with my given 4 steps.

  6. […] “Value cannot be null” when i connect SQL Server from SSMS […]

  7. I don’t even know how I ended up here, but
    I thought this post was good. I do not know who you are but definitely you’re going to a famous blogger if you aren’t already ;) Cheers!

  8. Geoffrey said

    Hello, after reading this awesome post i am too glad to share my knowledge here with friends.

  9. Sharyn said

    I like the helpful information you provide in your
    articles. I’ll bookmark your weblog and check again here regularly.
    I am quite sure I will learn many new stuff right here!
    Good luck for the next!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 2,126 other followers

%d bloggers like this: