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?


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


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 and join our FaceBook group!/groups

Thank you,

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

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

  1. Regina said

    It does help! 🙂
    Thank you!

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


  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.


    3. Above path you have to create one folder & its name is 2. Like as below.

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

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

Facebook photo

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

Connecting to %s

%d bloggers like this: